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
 SQL Server Development (2000)
 6.5version to sql 2000

Author  Topic 

Rita Bhatnagar
Posting Yak Master

172 Posts

Posted - 2002-01-02 : 10:43:16
We have one database on sql 6.5.We need to copy that database to sql 2000.What is the best way to do it?
Thanks for any help.
Rita

Nazim
A custom title

1408 Posts

Posted - 2002-01-02 : 11:06:12
the Most simplest way will be using DTS wizard. if both the servers are running.

HTH

----------------------------
Anything that Doesn't Kills you Makes you Stronger
Go to Top of Page

Rita Bhatnagar
Posting Yak Master

172 Posts

Posted - 2002-01-02 : 11:58:02
Both the servers are running but there is a problem.We can't see both database from single machine.Can we still use dts?
Thanks.
Rita

Go to Top of Page
   

- Advertisement -