May 20, 2008 at 12:10 pm
I am going to migrated SQL Database-2000 with Service Pack-1 to SQl 2005. But I do not want to change the Compatibility mode. So, what are the changes should require Or what is the list of changes, which I should keep in mind at the time of migration.
Thanks,
Aric
May 20, 2008 at 12:25 pm
Is this an upgrade (on the same server) or are you moving to a different box?
Before even considering upgrading to SQL 2005, I'd upgrade this server to SQL 2000 SP4, it includes a lot of fixes (including the one for SQL Slammer) and also means you're not making quite such a big jump when the time comes to move to SQL 2005.
May 20, 2008 at 12:30 pm
I'm not sure you can even directly upgrade any version of SQL 2000 that's lower than SP4. Anyway, you should also download and run SQL Server Upgrade Advisor - http://www.microsoft.com/downloads/details.aspx?familyid=1470E86B-7E05-4322-A677-95AB44F12D75&displaylang=en
Greg
May 20, 2008 at 12:54 pm
different box
May 20, 2008 at 1:23 pm
run a dbcc updateusage({databasename}) to fix inaccuracies caused by sql 2000. This inaccuracy won't happen on 2005, but if you migrate a database to 2005, you have to run this one time.
Also, I do:
- a dbcc checkdb before and after the upgrade
- do an update statistics after the upgrade (sp_updatestats is preferred)
Wilfred
The best things in life are the simple things
May 20, 2008 at 1:23 pm
Go thru this MS doc. once:-
SQL Server 2005 Upgrade Technical Reference Guide
Manu
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply