Sunday, March 11, 2012

Does In-place upgrade set compatibility level to 9.0

This may be very obvious and when I get to the first test server I will find out, but I only have a new installation of SQL2K5 so far to test with. I have several databases that need to be upgraded to run on 2K5, but the application requires them to run in 8.0 compatibility. Does this mean that an in-place upgrade is not an option?

I apologize if this is a silly question, but I have not yet found the answer specifically.

Thanks very much.

No, it does not change the compatibility level. It leaves it at 8.0.|||

So even on an in-place upgrade you still have to go to each database and manually change the compatibility level? This tells me that it only saves me the transfer or moving of the databases themselves, right?

Thanks!

|||

Saves you moving databases, having to export/import logins from master, jobs from msdb, etc.

But it doesn't assume you want compatibility level 9.0 -and that, in my opinion, is a good thing.

No comments:

Post a Comment