April 3, 2008 at 6:02 am
Hello all,
I am trying to upgrade a W2003 SP2 box with SQL2000 SP4 to SQL2005 SE, via in-place upgrade.
1. What setting (if any) do I have to choose to be able to finish the upgrade with all the databases at compatibility level 90? Or is that not possible, and do I have to set level to 90 via tsql or Management Studio?
Does changing this level change anything to the physical file; do I introduce issues when changing this level?
Thanks,
Hans
April 3, 2008 at 7:04 am
When you do an in-place upgrade the compatibility level will be upgraded to 90. You don't have to do anything.
If you attach a database you have to change the compatibilitylevwel manually either in SSMS or by running
EXEC dbo.sp_dbcmptlevel @dbname= 'mydatabase', @new_cmptlevel = 90
[font="Verdana"]Markus Bohse[/font]
April 4, 2008 at 6:55 am
Thank you for replying Marcus.
Do you also know if there is any difference in a database that still has level 80 and the same database that I have created by creating a new database under sql2005 and restoring a backup of the level-80 database in that new database (which has level 90)?
regards,
Hans
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply