question

sqlqa avatar image
sqlqa asked

Can we directly change Compatibility level from SQL 2000 to SQL 2008 ?

Hi, We are Currently using SQL Server 2008. We have SQL Server 2000 (80) Compatibility----6 Databases We have SQL Server 2005 (90) Compatibility----5 Databases We are planning to use SQL 2008 Features. 1)So Can we directly Change SQL Server 2000 (80) to SQL Server 2008 (100)? 2)After Make change Is Any Query to check Functions or SPs working correctly or not?
tsqlcompatibility-level
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

JohnM avatar image
JohnM answered
Yes you can make that change. However, I'd strongly suggest that you use the Upgrade Advisor as @Squirrel mentions as well as perform any type of regression tests that you might have available. I don't know of any script/tool that you can use to definitely say that you have a compatibility issue other than Upgrade Advisor. You can also check here: http://technet.microsoft.com/en-us/library/bb510680(v=sql.100).aspx to see what the differences are between 80/90/100. Hope this helps!
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Squirrel avatar image
Squirrel answered
You can use the Upgrade Advisor. [Using Upgrade Advisor to Prepare for Upgrades][1] [1]: http://msdn.microsoft.com/en-us/library/ms144256%28v=sql.105%29.aspx Best is still do this in your development environment and test out your application after changing it
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ashok2012 avatar image
ashok2012 answered
http://www.sqlservercentral.com/scripts/Compatibility/62093/ link provided script for check issues
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.