开发者

Upgrading from SQL Server 2005 to SQL Server 2008

开发者 https://www.devze.com 2022-12-09 17:33 出处:网络
Should I be scared of upgrading the database to SQL Server 2008? Is it a simple au开发者_如何学JAVAto-upgrade and everything works?

Should I be scared of upgrading the database to SQL Server 2008?

Is it a simple au开发者_如何学JAVAto-upgrade and everything works?

Is it worth it?


The upgrade from SQL Server 2005 to 2008 is a lot less "scary" than the upgrade from SQL Server 2000 to 2005. There are fewer T-SQL enhancements this time around, and the tools to manage SQL Server are very similar (so less of a learning curve).

The one thing that most people forget to do is to change the compatibility level of their databases after the server has been upgraded; you need to do this in order to use the new features inside a particular database after the server has been upgraded.


Perhaps you need to check out the features before asking a question like this.

Here's a link.


and here

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号