June 4, 2004 at 1:23 am
Hi !
how can i migrate a database from sql server 7 to sql server 2000 ?
June 4, 2004 at 9:14 am
One way would be to detach the SQL 7 database, move the files to the SQL 2000 data folder and reattach to the SQL 2000 instance.
Or if you have a backup, you can restore the backup directly to the SQL 2000 instance.
Either way you should reindex the database after this is done.
Hope this helps!
June 7, 2004 at 3:32 pm
I just did this last month. I was reusing the same hardware so I just did a restore from full backups. I did make sure I had everything scripted out just to be safe. I did have to use the scripts to recreate my DTS packages. It was a full weekend of work but on Monday everything reconnected and working. Also I think that when scripting out your users that their passwords are not scripted, so that may be an issue to resolve beforehand. I just recreated mine as I wanted to change naming format and strengthen the users passwords rules. Good Luck
|
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply