Post reply

Move DB from sql 2008 (TDE enabled) to sql 2005 - can it be done???????????

  • July 9, 2010 at 3:08 pm

    #223221

    Hello all, is it possible to take a database in SQL 2008 that is TDE enabled...and move it to a SQL 2005 environment? Obviously you'd have to turn off TDE & change the compatibility mode to 90.

    Our environment is sql 2008...but we need to send the database to an outside vendor that only has a 2005 environment.

    Seems simple enough...but I've tried every way possible and I cannot get it to work.

    If you've had success here please let me know.

    jz

  • July 9, 2010 at 3:12 pm

    #1191039

    thanks in advance. 🙂

  • July 9, 2010 at 3:22 pm

    #1191044

    You would need to export the data to a SQL 2005 database. Though the database is in Compat 90, it has been upgraded to SQL 2008 and can't be mounted to 2005.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

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

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