How to find deprecated syntax in sql server 2014

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

, +

Hi,

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.

Posted 9-Mar-15 1:05am

pratap420

Add a Solution

Comments

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

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

phil.o · Answer 1 · 2015-03-09T01:15:00

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.

Maciej Los · Answer 2 · 2015-03-09T05:47:00

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!

Posted 9-Mar-15 5:47am

Maciej Los

CHill60 · Answer 3 · 2015-03-09T06:11:00

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

How to find deprecated syntax in sql server 2014

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0