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
精彩评论