I am planning to upgrade a SQL Server 2000 instance to a SQL Server 2005 instance.
我打算将SQL Server 2000实例升级到SQL Server 2005实例。
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?
我不打算更改任何数据库代码,因此我不会利用任何SQL2005特定语法。有没有理由将我的兼容性设置得更高(达到9级)?或者是否可以在兼容级别8处离开?
5 个解决方案
#1
There are two ways to look at this:
有两种方法可以看出这个:
- If you want to change your code (or install some collaborating SQL2005/2008 servers) in the future, your compatibility mode will affect that decision
- If you haven't run the Upgrade Adviser, you may not be able to upgrade :) compatibility level 9 disables certain syntaxes and features that were available in 8.
如果您希望将来更改代码(或安装一些协作的SQL2005 / 2008服务器),您的兼容模式将影响该决定
如果您尚未运行升级顾问,则可能无法升级:)兼容级别9禁用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 :)
所以,简单的答案是不,你不必增加你的竞争水平,但是你也要用这个盒子来考虑你的未来:)
#2
Its fine to leave it at 8 until you wish to upgrade.
可以将它保留在8,直到你想升级。
#3
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.
只需要一点点 - compat level 90可以支持旧的ANSI-89外连接语法(* =,= *)。如果您决定切换,请确保先检查了代码库。
#4
Well Reports that u get with level 90, is very nice... that alone is incentive to upgrade...
你得到90级的报告是非常好的......仅此一点就是升级的动力......
#5
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.
因此,除非您知道更改兼容级别不会破坏任何内容,否则您应该明确升级。所以在采取任何机会之前要做彻底的检查。
#1
There are two ways to look at this:
有两种方法可以看出这个:
- If you want to change your code (or install some collaborating SQL2005/2008 servers) in the future, your compatibility mode will affect that decision
- If you haven't run the Upgrade Adviser, you may not be able to upgrade :) compatibility level 9 disables certain syntaxes and features that were available in 8.
如果您希望将来更改代码(或安装一些协作的SQL2005 / 2008服务器),您的兼容模式将影响该决定
如果您尚未运行升级顾问,则可能无法升级:)兼容级别9禁用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 :)
所以,简单的答案是不,你不必增加你的竞争水平,但是你也要用这个盒子来考虑你的未来:)
#2
Its fine to leave it at 8 until you wish to upgrade.
可以将它保留在8,直到你想升级。
#3
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.
只需要一点点 - compat level 90可以支持旧的ANSI-89外连接语法(* =,= *)。如果您决定切换,请确保先检查了代码库。
#4
Well Reports that u get with level 90, is very nice... that alone is incentive to upgrade...
你得到90级的报告是非常好的......仅此一点就是升级的动力......
#5
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.
因此,除非您知道更改兼容级别不会破坏任何内容,否则您应该明确升级。所以在采取任何机会之前要做彻底的检查。