Migrating 7.0 Databases to 2000

• bryan99y

  SSCarpal Tunnel

  Points: 4672

  More actions

  January 28, 2002 at 9:21 am

  #64412

  We are in the process of Migrating to SQL Server 2000 from SQL Server 7.0.

  There will be two new Servers purchased for this process.

  What is the best method for the Database Migration ?

  - Copy Database Wizard ?

  - DTS ?

• K. Brian Kelley

  SSC Guru

  Points: 114642

  More actions

  January 28, 2002 at 9:56 am

  #422731

  Copy Database Wizard is, I believe, still using DTS. In any case, here's a previous discussion on the same issue:

  http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=1707&FORUM_ID=5&CAT_ID=1&Topic_Title=How%20to%20move%20Database%20From%20SQL7%20to%20SQL2000&Forum_Title=Administration

  K. Brian Kelley

  bkelley@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/bkelley/

  K. Brian Kelley
  @kbriankelley

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736255

  More actions

  January 28, 2002 at 10:21 am

  #422735

  Is this the same server begin upgraded? If so, then you should be able to upgrade through setup. Otherwise, use Brian's suggestion.

  Steve Jones

  steve@dkranch.net

• bryan99y

  SSCarpal Tunnel

  Points: 4672

  More actions

  January 28, 2002 at 10:53 am

  #422751

  We have 2 new servers for the Migration.

• bryan99y

  SSCarpal Tunnel

  Points: 4672

  More actions

  January 28, 2002 at 10:58 am

  #422754

  We can shut down the 2 services for SQL Server.

  Would it be better to :

  1. Shut down the services - mssqlserver & sqlserveragent.

  2. Copy the DB & Log files to the new server

  3. sp_attachdb

  (This way I can aviod detaching the databases on the source (7.0) server)