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?

more ▼

asked Jul 25 at 01:54 PM in Default

sqlqa gravatar image

520 10 20 29

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

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!
more ▼

answered Jul 27 at 02:12 PM

JohnM gravatar image

6.9k 1 3 7

(comments are locked)
10|1200 characters needed characters left

You can use the Upgrade Advisor.

Using Upgrade Advisor to Prepare for Upgrades

Best is still do this in your development environment and test out your application after changing it
more ▼

answered Jul 26 at 12:50 AM

Squirrel gravatar image

2.5k 1 2 4

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jul 25 at 01:54 PM

Seen: 523 times

Last Updated: Jul 27 at 02:12 PM