October 4, 2005 at 10:46 pm
Can any one suggest, migrating a datbase from SQL server 7 to 2000 what steps needs to be taken before and after migration.
its an urgent one please.
October 4, 2005 at 11:00 pm
You just do the full backup database in SQL 7 and then restore in SQL 2000.
October 5, 2005 at 12:21 am
That fine. We do this migration by backup and restore method. But prior to back in SQL 7.0 and after restoring the backup (SQL 7.0) in SQL2000
what steps needs to be taken for Migration. That is my Question.
October 5, 2005 at 12:43 am
You need to re-setting the database configuration, if you want a database can run faster then before. But if your database has been setting in the good configuration before, you don't need to do that, just change the connection in you application, if you have application connected to the database.
October 5, 2005 at 2:11 am
Hi,
Restore is good what about the Logins.
Tranfer all the logins also.If u have replication set create the script of it .
If u have scheduled jobs script the jobs or tranfer them through dts.
HTH
From
Killer
October 5, 2005 at 3:14 am
Yes you're right, every object must be transfer to
October 8, 2005 at 7:55 pm
Why make life hard for yourself? Don't script the jobs and packages, just backup and restore msdb along with your user databases.
October 11, 2005 at 3:09 pm
Here is a link to methods of upgrading and 7.0 to 2000 and addresses issues of logins and orphaned users.
http://www.sqlteam.com/item.asp?ItemID=9066
Steve
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply