SQL 7.0 to 7.0

  • Hi everyone
     
    I have a SQL 7.0 Server which I've been told they want to upgrade the hardware for.
     
    So I will have a brand new server, which I need to move all the databases too.
     
    It will still be SQL 7.0, as the software that uses the database is that old it only works with SQL 7.0  So I can't go to another version of SQL unfortunately.
     
    How would I go moving the databases from the old to the new server?
     
    If it was 2000 I would do the following:
    1. Backup all databases (including system ones)
    2. Detach the databases from old server.
    3. Attach master, model & msdb databases on new server.
    4. Attach user databases.
     
    Now, would this work on a SQL 7.0 server or is there a better way to go around doing this?
     
    Thanks
  • Hello,

     

    First: I think it is a hard job to detach/attach master database 🙂

    Second: it is a final 'no' in not beeing able to run the 2k version? 2k has a compatibility level that can be set to '70'.

    Third: Regarding the move between sql7 and sql7, you may check this http://support.microsoft.com/kb/224071 and http://support.microsoft.com/kb/304692

    ...

    N: I moved some time ago a 65 to 2k with only performance penalties (I used 'tempdb in ram' in 65 and a lot of intermediary #tables in procedures, so in 2k I had to use table variabiles). You should pay attention to logins and users and to security etc..

     

    Success

    E.I.

  • Hi,

    Is both the servers on LAN (Local Area Network) if yes,then you can use the DTS Wizards to transfer all the Database and its all Objects into that server.

    If No, Then Stop the Sql Sever Sevices.and copy all the *.MDF & *.LDF FILE and then attach it as mentioned in above comments....

    Regards,

    Amit Gupta........

     

     

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

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