Post reply

restore an sql 2005 backup file to sql 2000 db

  • September 1, 2007 at 11:21 pm

    #180753

    how can i restore an sql 2005 backup file to sql 2000 db?

  • September 2, 2007 at 6:43 pm

    #730952

    Unfortunately this cannot be done.

  • September 2, 2007 at 11:11 pm

    #730961

    Sam -

    You can get your data back to SQL 2000 via DTS or SSIS package as long as the collations, table structures, etc. are all compatiable with SQL 2000 (no SQL 2005 only data types).

    Joe

     

  • September 4, 2007 at 6:08 am

    #731171

    There are some synchronization tools that are available.  Red-Gate has one that is pretty good, Quest software has a free one, but you get what you pay for, and there are loads of other ones out there.

    In your case, the Quest software freeware comparison suite will actually help.  It will generate a script file for all of your database objects and all of the data to make another database that matches the original.  The script it will generate will work on a SQL 2000 database if you have not used any SQL 2005 specific features.

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

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