October 21, 2009 at 1:33 am
Hi Task,
Can anyone share the check list for Migrating the sql 2000 databases to sql server 2005.
What are steps involved from scratch to migrate the 2000 databases to 2005.
Also, would like to know the Pre-requistes and Post - migration steps before actaully going to LIVE.
what kind of measures should be taken while migrating logins, jobs ,dts packages to 2005, Alerts, replication measures, service accounts etc... How to migrate the system databases .... so on
How would service packs will have an affect upon migrating sql 2005?
Would appreciate sincere replies.
Thanks in Advance
October 21, 2009 at 3:37 am
You can perform a side by side upgrade as follows,
1.Take full backup of all the databases in SQL 7 or SQL 2000 for precautionary purpose
2.Script all the logins using http://support.microsoft.com/kb/246133 in SQL 7 or SQL 2000
3.Script all the jobs in SQL 7 or SQL 2000 using the below link http://msdn2.microsoft.com/en-us/library/aa177024(SQL.80).aspx
4.Install SQL Server 2005
5.Detach all the user databases in SQL 7 or SQL 2000 and copy the files
6.Attach all the user databases in SQL 2005
7.Run the script taken in Step 2 to recreate the logins
8.Run the script taken in Step 3 to recreate the jobs
9.Inorder to migrate DTS packages to SSIS you can refer this link, http://www.simple-talk.com/sql/sql-server-2005/dts-to-ssis-migration
10.Once everything is completed login and check the application functionality
The below link is helpful for getting started with upgrading to SQL Server 2005, http://www.microsoft.com/downloads/details.aspx?FamilyID=3d5e96d9-0074-46c4-bd4f-c3eb2abf4b66&DisplayLang=en
Sanket Ahir
Don't run behind the success, Try to be eligible & success will run behind u......
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply