升级顾问超过错误或警告 [英] Upgrade adviser surpassing errors or warnings

问题描述

你好，

我在MS SQL 2008 R2上有一个数据库，但兼容模式为80.我没看到没有将此更改为100的原因。但是，我针对此数据库运行了升级顾问程序，并且没有收到任何警告或错误。然而，当我手动搜索过程时，我注意到旧的
学校语法，如* = in。所以我不能完全依赖升级顾问。是否有可用的DB兼容级别顾问工具，或者运行升级顾问是否足以将兼容级别从80更改为100？

提前感谢

解决方案

Hi
sqldba_24，

 

您可以尝试使用
Microsoft SQL Server 2008 R2最佳实践分析工具工具。然而，这些工具不会捕获所有内容，例如弃用的东西。

 

建议对数据库进行完整备份，并使用更新的兼容模式在实例上恢复它并对你的数据库进行测试。

 

< p style ="margin：0in; font-family：Calibri; font-size：11.0pt">顺便说一句，当存储过程执行时，它使用定义它的数据库的当前兼容级别。当数据库的兼容性设置发生更改时，所有存储的
过程都会自动重新编译。

 

最好的问候，

< p style ="margin：0in; font-family：Calibri; font-size：11.0pt"> Emily

Hello,

I have a database on MS SQL 2008 R2 but with compatibility mode 80. I dont see a reason in not having this changed to 100. However I ran the upgrade advisor against this database and got no warnings or errors. However when I manually search procs I notice old school syntax like *= in them. So I cannot totally rely on upgrade advisor only. Is there a DB compatibility level advisor tool available or would running an upgrade advisor be enough to change the compatibility level from 80 to 100?

Thanks a ton in advance

解决方案

Hi sqldba_24,

 

You can try to use the Microsoft SQL Server 2008 R2 Best Practices Analyzer tool. However these tools are not going to catch everything such as the deprecated stuff.

 

It is suggested to make a full backup of your database and restore it on the instance with newer compatibility mode and do a test for your database.

 

By the way, when a stored procedure executes, it uses the current compatibility level of the database in which it is defined. When the compatibility setting of a database is changed, all of its stored procedures are automatically recompiled accordingly.

 

Best Regards,

Emily

这篇关于升级顾问超过错误或警告的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！