将SQL2005应用程序移至SQL2008 [英] Moving SQL2005 app to SQL2008

问题描述

我很快将把我们的生产SQL2005应用程序迁移到SQL2008.在搬家之前/之后需要注意什么吗?有任何警告和建议吗?

I will be moving our production SQL2005 application to SQL2008 soon. Any things to lookout for before/after the move? Any warnings, advices?

谢谢！

推荐答案

将数据库移动到2008服务器后，更改数据库的兼容性级别.默认情况下，它仍将保持旧的兼容性级别.这样，您就可以在该数据库中使用SQL 2008中的新功能了.

Change your compatibility level on the database after moving it to the 2008 server. By default, it will still stay at the old compatibility level. This will let you use the new goodies in SQL 2008 for that database.

如果您使用的是SQL 2008企业版，并且没有以80-90％的CPU运行，请打开数据压缩并压缩所有对象.在这方面有很大的性能提升.不幸的是，您必须为每个对象手动进行操作-没有一个开关可以抛出.

If you're using the Enterprise Edition of SQL 2008 and you're not running at 80-90% CPU on the box, turn on data compression and compress all of your objects. There's a big performance gain on that. Unfortunately, you have to do it manually for every single object - there's not a single switch to throw.

如果您不使用Enterprise，则在提高兼容性级别之后，重新构建所有索引. (对于任何版本升级，这几乎都是正确的.)

If you're not using Enterprise, after upping the compatibility level, rebuild all of your indexes. (This holds pretty much true for any version upgrade.)

这篇关于将SQL2005应用程序移至SQL2008的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！