x

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, 2014 at 01:54 PM in Default

avatar image

sqlqa
520 22 30 35

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

3 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, 2014 at 02:12 PM

avatar image

JohnM
12.4k 3 7 14

(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, 2014 at 12:50 AM

avatar image

Squirrel
2.7k 1 4 7

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

answered Feb 09, 2015 at 04:33 PM

avatar image

ashok2012
420 2 9

(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.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x391
x11

asked: Jul 25, 2014 at 01:54 PM

Seen: 775 times

Last Updated: Feb 09, 2015 at 04:33 PM

Copyright 2016 Redgate Software. Privacy Policy