我是否应该将升级后的数据库的兼容性级别从 8 更改为 9？
我计划将 SQL Server 2000 实例升级到 SQL Server 2005 实例。
我不会更改任何数据库代码，因此我不会利用任何 SQL2005 特定语法。 是否有任何理由将我的兼容性设置得更高（至级别 9）？ 或者可以保留兼容级别 8 吗？
I am planning to upgrade a SQL Server 2000 instance to a SQL Server 2005 instance.
I am not going to change any database code, so I won't be taking advantage of any SQL2005 specific syntax. Is there any reason to set my compatibility higher (to level 9)? Or is it ok to leave at compatibility level 8?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（5）
有两种方法可以查看此问题：
安装一些协作
SQL2005/2008 服务器）在未来，
您的兼容模式会影响
该决定
升级顾问，你可能无法
升级:) 兼容性级别 9
禁用 8 中可用的某些语法和功能。
因此，简单的答案是不，您不必提高兼容级别，但您也必须考虑此框的未来:)
There are two ways to look at this:
install some collaborating
SQL2005/2008 servers) in the future,
your compatibility mode will affect
that decision
Upgrade Adviser, you may not be able
to upgrade :) compatibility level 9
disables certain syntaxes and features that were available in 8.
So, simple answer is no you don't have to increase your compat level, but then you've to consider your future with this box too :)
最好将其保留为 8，直到您想要升级为止。
Its fine to leave it at 8 until you wish to upgrade.
只是一个小问题 - 兼容级别 90 不再支持旧的 ANSI-89 外连接语法（
*=、=*）。 如果您决定进行切换，请确保您已先检查代码库中是否有这些内容。Just a small point - compat level 90 drops support for the old ANSI-89 outer join syntax (
*=,=*). If you do decide to switch, make sure you have checked your code base for those first.嗯，报告说你达到了 90 级，非常好......仅此一点就激励升级......
Well Reports that u get with level 90, is very nice... that alone is incentive to upgrade...
兼容性级别不仅仅是一个偏好问题，还取决于您如何使用数据库
您可以检查此链接上的更改：
http://msdn.microsoft.com /en-us/library/bb510680.aspx
因此，除非您知道更改兼容性级别不会破坏任何内容，否则您应该明确升级。 因此，在冒险之前一定要彻底检查一下。
Compatibility level is not just a question of preference, its a matter of how you use the database
you can check what changed on this link:
http://msdn.microsoft.com/en-us/library/bb510680.aspx
So unless you know that changing the compatibility level will not break anything you should definetly upgrade. So do a thoroughly check before taking any chances.