如何在sql server 2014中找到已弃用的语法 [英] How to find deprecated syntax in sql server 2014

问题描述

现在我的应用程序正在使用Sql server 2008 R2数据库。由于许可证问题，客户希望更改为Sql server 2014.



现在我打算检查与程序，表格等所有对象的兼容性检查....



是有没有命令/程序来检查这种兼容性检查？因为我的应用程序有非常多的对象。我正在寻找任何替代方式，而不是检查每个单独的对象。



感谢您的支持。

先谢谢。

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.

推荐答案

我不确定你是否需要它。



您可以强制您的数据库在您喜欢的任何SQL版本模式下运行，直到当前版本;它将使用2014版本的许可证，但数据库本身可以在兼容模式下运行。



老实说，我确实在我的客户端上维护了相当数量的数据库'服务器，这从来就不是问题。



这是一个关于SQL Server兼容模式的链接：

ALTER DATABASE兼容级别（Transact-SQL） [ ^ ]



请注意，您没有义务使用Transact- SQL脚本，您可以使用SQL Server Management Studio（如果已安装）执行此操作。您只需右键单击数据库，然后在属性网格中选择所需的兼容模式（我不记得它是否在第一个或第三个选项卡上）。



希望这会有所帮助。好的。

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.

我想你应该从这里开始：

SQL Server 2014中已停止的数据库引擎功能 [ ^ ]

SQL中不推荐使用的数据库引擎功能Server 2014 [ ^ ]



我几乎可以肯定你所寻找的命令/工具不存在！

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!

继续其他解决方案和注释，您可以将整个数据库编写为文本文件...右键单击数据库名称，任务，生成脚本。



然后您可以使用文本编辑器（例如UltraEdit，Notepad ++）搜索并在必要时更改li上列出的已弃用功能解决方案2中的nks。



如果已经使用了嵌入式Sql，请不要忘记搜索应用程序代码

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

这篇关于如何在sql server 2014中找到已弃用的语法的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！