May 14, 2009 at 1:47 pm
We are moving databases from SQL 2000 to 2008, do we have to convert the database from compatibility mode to 2008? Is there anything special we need to do?
May 14, 2009 at 2:32 pm
You don't have to convert them. SQL 2008 still supports compat 80. Doesn't support 75. It goes back two major versions.
You might, on the other hand, want to convert them. Lots of things can be gained by doing so, including a lot of very nice new features from 2005 and 2008.
If you do so, there are a few things you'll need to do, like updating the stats on all your tables and indexes. MSDN has a list of the things you need to do, but none of them are particularly difficult, and they're all easy to script out.
The big deal, however, is making sure all your code works. There are some surprising incompatibilities between 2005/2008 and 2000. That's a matter of testing procs and such like crazy on a dev box before you try to upgrade. There's no real shortcut to it.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
June 30, 2009 at 10:48 am
The previous poster is right on.. In addition to what he has to say I would run the Upgrade Advisor that MS provides to give you an idea of what it sees that will be a problem. It is available from the SQL 2008 Feature Pack page, or from here:
http://go.microsoft.com/fwlink/?LinkId=147019
CEWII
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply