Post reply

Upgrade to SQL 2008

  • March 26, 2009 at 8:21 am

    #128900

    I upgraded to SQL2008 from SQL2005 on a test box just to see what would happen. Amazingly it went very smoothly. I used the upgrade wizard in SQL2008 to do a stand alone upgrade, no detach attach upgrade.

    Looking over the databases after the upgrade I noticed that the compatibility level was still set to 90, i.e. SQL2005. Do I need to change the compatibility level to 100, i.e. SQL2008 in order for things to work properly?

    Thanks.

    Ralph

  • March 26, 2009 at 8:34 am

    #966716

    Yes, if you want to use the new 2008 features.

  • March 26, 2009 at 9:16 am

    #966762

    Great. Thanks.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply