Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
raguyazhin
Posting Yak Master
105 Posts |
 Posted - 2011-05-30 : 03:50:02
|
| Hi we migrated our SQL Server Database SQL Server 2000 EE to SQL Server 2005 SP4 EE 64 bit in our Concern.But still our user databases Compatibility Level is 80 in this database contain more than 2500 user tables and 1500 store procedures and views.Now we plan to change the Compatibility Level to 90.what are the changes we will do in our user database. kindly suggest me for do this work successfully.--Ragu |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2011-05-30 : 13:26:57
|
| You need to review the changes introduced in SQL Server 2005 and validate that your code is not using any deprecated features that will no longer work when you change the compatibility level.Lookup the changes in books online - and then start reviewing your code.If you still have the 2000 system available, download and install the Upgrade Advisor for SQL Server 2005. This will identify most (not all) of the issues that you will need to address.Once you have that, change the compatibility level on a TEST SYSTEM and start testing everything in your system. Once you are comfortable that you have corrected everything and those changes have been migrated to production - schedule the change. Just be prepared to handle any of the fallout from the change - as there is a real possibility that someone will have issues after the change and you will need to be able to fix it right away.Jeff |
 |
|
|
|
|
|
Compatibility Level 80 to 90