After migrating a database server from sql server 2005 to 2008 R2, do you often change the compatibilty level of each database from SQLserver 2005(90) to 2008(100) or you don't do the change just keep (90),
As long as you have tested the application that uses the DB and also if you have run the Upgrade advisor and did not find any issue, why would you not change the compatability level to 100?
We do it for all the DB's that we upgrade.
-Roy
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply