June 23, 2008 at 1:32 am
Hi we are planning o migrate from
SQL Server 2000 to SQL Server 2005
I am worndering if anyone has created a checklist and would like to share
any issues and best practices?
Thanks
June 23, 2008 at 7:56 am
You can refer the links below
[font="Verdana"]SQL Server 2005 Upgrade Handbook
Migrating from SQL 2000 to SQL 2005
Upgrading a Database SQL 2000 to SQL 2005[/url][/font]
Regards..Vidhya Sagar
SQL-Articles
June 23, 2008 at 8:34 am
test your applications in QA
if you can do a side by side upgrade with new server name, etc. easier to roll back if need be
June 23, 2008 at 9:08 am
Check on the SQL Server 2005 upgrade Advisor.
QuickTips:
Are you having the same Drive/path structure on SQL 2005 Server.
you can Detach-Attach your Databases.
Restore from backups.
Check for Paths if you get any kind of error's.
After Restore or Attach change the Database Compatibility level to 90.
Copy all logins from SQL 2000 to 2005 using this: http://support.microsoft.com/kb/246133
Check all permissions to all objects.
Check for orphaned users in your databases using :
sp_msforeachdb @command1='USE [?] Print ''?'' EXEC sp_change_users_login ''report'' ' THis will help you get all the orphaned users across all the databases.
Repair the orphaned user with sp_change_users_login 'UPDATE_ONE','username','username';
Then it will be time to check the code/Syntax differences between SQL 2000 and 2005.
Quicktip here: the Query with join type TABLENAME.* will not work in SQL 2005.
Before moving Jobs, change/Create OPerators and setup Database/SQL Mail.
Rest Move Jobs by either copying the MSDB Database Over to SQL 2005 or Script them out on SQL 2000 and recreate them on SQL Server 2005.
DTS: My personal advice: you will have to rewrite all your DTS Packages into SSIS.
There were some of the TIPS...
Maninder
www.dbanation.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply