Click here to Skip to main content
14,421,081 members
Rate this:
Please Sign up or sign in to vote.

Now my application is using Sql server 2008 R2 database .Due to licence problem ,Clients wants to change to Sql server 2014.

Now I am planning to check compatibility checks with all the objects like procedures,tables ,....

Is there any commands/procedure to check this compatibility checks? As my application has very huge number of objects .I am looking for any alternate way instead of checking each and every individual object.

Appreciate your support.
Thanks In advance.
Kornfeld Eliyahu Peter 9-Mar-15 7:13am
2014 is backward compatible with 2008 R2 - so what the problem? You need not to change anything to move from 2008 R2 to 2014...
pratap420 9-Mar-15 7:51am
Thanks for update.But I need to check if any breakage in the code/syntax wise deprecation
Rate this:
Please Sign up or sign in to vote.

Solution 1

I'm not sure you need it.

You can force your database to run Under any SQL version mode you like until the current one ; it will be using the licence of the 2014 version, but the database itself can run in compatibility mode.

Honestly, I do maintain a fair number of databases on my clients' servers, and this has never been an issue.

Here's a link regarding SQL Server's compatibility modes:
ALTER DATABASE Compatibility Level (Transact-SQL)[^]

Note that you are not obliged to do it with a Transact-SQL script, you can do that with SQL Server Management Studio, if it is installed. You just have to right-click on the database, and select the desired compatibility mode in the property grid (I don't remember if it is on the first or the third tab, though).

Hope this helps. Kindly.
_Asif_ 9-Mar-15 7:57am
I would like to add here that you still need to verify your application in a test environment to ensure that application works as needed and to avoid any surprises. These kind of migrations need to be monitor very cautiously
Rate this:
Please Sign up or sign in to vote.

Solution 2

I think you should start here:
Discontinued Database Engine Functionality in SQL Server 2014[^]
Deprecated Database Engine Features in SQL Server 2014[^]

I'm almost sure that command/tool you are looking for does not exists!
Rate this:
Please Sign up or sign in to vote.

Solution 3

Further to the other solutions and comments, you can script your entire database to a text file ... Right click on Database name, Tasks, Generate Scripts.

You can then use a text editor (e.g. UltraEdit, Notepad++) to search for and if necessary change the deprecated features listed on the links in Solution 2.

Don't forget to search your application code for any embedded Sql if it has been used

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100