Using DTS to move data from a SQl-Server 6.5 DB (Newbie question)

Using DTS to move data from a SQl-Server 6.5 DB (Newbie question)

Post by S. Jonsso » Sat, 17 Aug 2002 01:47:11



Hi,

Is it possible to use DTS to move a database (or a part of
a database) from SQl Server 6.5 to sql-Server 2K?

 
 
 

Using DTS to move data from a SQl-Server 6.5 DB (Newbie question)

Post by Allan Mitche » Sat, 17 Aug 2002 03:23:02


Yes.

Create an ODBC dataSource to your 65 server.  Use that as the Source
of a transform.  Have a lok at this tutorial.

Building a Package in the DTS Designer
http://www.sqldts.com/default.aspx?t=6&s=107&i=278&p=1&a=7

Allan
www.SQLDTS.com

On Thu, 15 Aug 2002 09:47:11 -0700, "S. Jonsson"


>Hi,

>Is it possible to use DTS to move a database (or a part of
>a database) from SQl Server 6.5 to sql-Server 2K?

Allan Mitchell
www.SQLDTS.com