Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Import SQL 6.5 table into SQL 2000?

Author  Topic 

GB
Starting Member

22 Posts

Posted - 2006-04-04 : 17:39:12
Is there a good way to do this? I'm hoping someone will tell me of a DTS tool that I can use.
Thanks for any help
Gary

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-04-04 : 17:46:44
The best way is to use the Upgrade wizard in SQL Server 2000.

Tara Kizer
aka tduggan
Go to Top of Page

GB
Starting Member

22 Posts

Posted - 2006-04-05 : 11:48:28
Thanks!
Go to Top of Page

GB
Starting Member

22 Posts

Posted - 2006-04-06 : 10:08:47
Tara - when I use the upgrade wizard, will it copy the database to my new server and leave the old server as is......or will it move the old database and upgrade it?
Thanks
Gary
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-04-06 : 11:57:23
It will not modify the source database.

Tara Kizer
aka tduggan
Go to Top of Page
   

- Advertisement -