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 Administration (2000)
 SQL server

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-02-20 : 08:08:25
writes "I need to move my Sqlserver 7 to sql server 200o in another computer"

X002548
Not Just a Number

15586 Posts

Posted - 2004-02-20 : 10:24:38
Me too...I need to move 6.5 to 2k...

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=32669



Brett

8-)
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-02-20 : 12:25:56
7.0 to 2000 is a lot easier than 6.5 to 2000. For 7.0 to 2000, you can simply detach your database in 7.0, then attach it in 2000. Or you can use BACKUP/RESTORE method. With 6.5, you can't do that. You have to use the upgrade wizard or export/import the data on your own.

Tara
Go to Top of Page
   

- Advertisement -