Moving SQL2005 Application to SQL2008

Question

In the near future I will transfer our production application SQL2005 to SQL2008. Any things to observe before / after moving? Any warnings, tips?

Thank!

Answer 1

Check this article for known change changes .

Answer 2

Change the compatibility level in the database after moving it to the 2008 server. By default, it will remain at the same compatibility level. This will allow you to use the new goodies in SQL 2008 for this database.

Enterprise Edition SQL 2008, 80-90% CPU , . . , - .

Enterprise, , . ( .)

Answer 3

.

.

- , , .

2000 2005 , , , , .

, 2000, , , - , , .