Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
McGurk
Starting Member
21 Posts |
 Posted - 2009-08-18 : 11:57:08
|
| My database was moved into v08 from v05. I noticed the Compatibility remained at 90. Is it best to leave it there or would it be better to change it to 100? I have a web application and windows application running against this db. Will changing the Compatibility affect them? Also, I have two other dbs that will be moved to v08. Besides web applications, they have SSIS pkgs running against them. Will there be issues there if I up the Compatibility to 100? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2009-08-18 : 12:47:00
|
| You should change the compatibility level to 100 in a test environment and when you are satisfied that the application works as desired still, you can then change it in production. Switching compatibility levels after an upgrade is a manual step, the upgrade never moves the compatibility level up for you.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong." |
 |
|
|
|
|
|
Compatibility 2005 to 2008