Post reply

Moving DB from SQL 2000 to SQL 7???

  • July 7, 2005 at 3:25 pm

    #363103

    Is it possible to restore DB which was copied from SQL7 to SQL 2000 back to SQL 7?

    Mark

  • July 7, 2005 at 3:52 pm

    #572112

    I sure you can't do it with a backup and restore like you can going the other way.  But you should be able to move the SQL 2000 data back to 7 with DTS or another migration tool.  Of couse if you used any of the features that were new to SQL 2000 these would be lost. 

     

    My hovercraft is full of eels.

  • July 7, 2005 at 3:54 pm

    #572113

    I've tried to copy it back using DB Wizard but got an error message - saying that it requires sql 8.

    Mark

  • July 7, 2005 at 4:10 pm

    #572114

    From 2000 Client tools you can manage 7.0, not the other way around 


    * Noel

  • July 7, 2005 at 4:31 pm

    #572119

    I've tried to copy it from 2000 client, from sql7 you can't even connect to 2000.

    Mark

  • July 8, 2005 at 6:07 am

    #572254

    Try scripting it, recreating it (you might need to change a little syntax)and then use bcp to dump your data and suck it back in.

  • July 8, 2005 at 7:03 am

    #572294

    if you have access to a SQL7 instance, you can use the Import/Export wizard to move the database to the SQL7 instance, then back it up, and the backup would be restorable on a SQL 7 again; i have to do this all the time.

    here's teh basic steps:

    From Enterprise Manager:

    Right Click the 2000db>>All Tasks>>Export Data

    The 2000db is already selected, press next and choose the SQL7 server, and select new for the db, and give it an appropriate name

    This is the most important piece...select the thrid option button "Copy Objects and Data between SQL Server Databases"

    this option will make sure it copies everything...constraints, foreign keys, stored procs, everything; the default option copies just the tables, and can leave a lot of stuff off.

    after clicking next, uncheck default options, click the option button and unceck the first and third option buttons...you do not want to "copy database users and database roles"

    and you do not want to copy "object level permissions";

     

    finish it from there; it is much slower than a backup and restore, but the db, once on the SQL7 instance, can be backed up and sent to the other sql7 instance.

    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!

  • July 8, 2005 at 7:20 am

    #572305

    Thanks Lowell - Appreciate your help - Mark

Viewing 8 posts - 1 through 7 (of 7 total)

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