SQL 7.0 to 7.0

• Krissy

  Ten Centuries

  Points: 1185

  More actions

  June 5, 2006 at 9:52 pm

  #61777

  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

• emanuel ionescu

  SSC Eights!

  Points: 889

  More actions

  June 7, 2006 at 5:17 am

  #642229

  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.

• AMIT GUPTA-263376

  SSCarpal Tunnel

  Points: 4244

  More actions

  June 7, 2006 at 9:19 am

  #642310

  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........