Post reply

Attempting to Convert from SS2K to SS2K8 -- Having problem changing Compatibility

  • August 31, 2011 at 10:15 am

    #256458

    I am running a prototype of our production environment in Development and have been asked to scout out the problems we would have doing a conversion from SS2K to SS2K8.

    I ran the SS "Best Practices" wizard and the "Upgrade Advisor". Then I went to change the compatibility from 2000 to 2008. In the Object Explorer, I selected the database, right-clicked and selected Properties, then selected Options. In the Compatibility List Box, only SS2k and SS7 were listed! There was no SS2K5 or SS2K8!

    Does anyone have an idea how I would get SS2K8 to be one of the options?

    Thanks ahead of time for any help you can offer!

    -- Tom

  • August 31, 2011 at 10:21 am

    #1375577

    What version of SQL is that on, the 2000 or the 2008?

    SELECT @@version?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 31, 2011 at 1:29 pm

    #1375675

    You haven't suggested in your post that you've actually done the upgrade yet - just ...

    I ran the SS "Best Practices" wizard and the "Upgrade Advisor". Then I went to change the compatibility from 2000 to 2008.

    You can't put it into 2008 compatibility mode without upgrading it first.

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

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