Post reply

Compatibility question...

  • October 26, 2007 at 10:54 am

    #119126

    Quick question...

    I have a 2005 instance with a DB that is set to compatibility level 80 - I am trying to update a test environment (2000 instance) with the DB and am hitting a wall. I have tried to restore and detach/attach, but neither method is working. Is it even possible???

    Thanks in advance - J.

  • October 26, 2007 at 11:18 am

    #745839

    a SQL 2005 database, no matter what compatibility level it was set for, is still in SQL2005 format, and can't be restored or attached by previous versions of SQL.

    compatibility level just says what syntax rules will be applied against TSQL's performed against the database, and not how it will be stored behind the scenes.

    you'll need to use DTS to get all tables and objects from 2005 into 2000, instead of trying to restore...a bit slower, but it works.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • October 26, 2007 at 11:56 am

    #745863

    Thanks for the detail - that helps considerably.

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

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