March 25, 2015 at 6:54 am
Hi All,
I've inherited a database running on SQL 2008 SP4 which is in SQL 2000 compatibilty mode.
I don't know if this was done for a reason or if it was migrated and someone simply forgot to change it to run native.
Are there any tools or scripts available to check if a database is using any features that will no longer work on SQL 2008 ?
I'm guessing the 2000 - 2008 upgrade advisor isn't much use once it's already been upgraded?
Thanks!
March 25, 2015 at 7:35 am
To check if any scripting is incompatible you could script out the database objects, create a blank database not running 2000 compatibility mode and see if the script execute and create all the objects. You might need to run the scripts on a 200 compatible mode just to make sure there are no bogus ones in these. If the database in complex with a lot of dependencies it may be difficult to do as you need to run the script in a particular order.
March 25, 2015 at 11:40 am
I would try running the Upgrade Advisor against the database. I'm not 100% sure you can, but that will tell you specifically what won't work. You can also try to identify deprecated code by using trace [/url]or extended events[/url] to identify deprecated commands.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply