In-place upgrade to SQL2005: database compatibility level.

  • 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

  • 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]

  • 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