SQL 7 SP4 --> SQL 2005 (Moving databases)

• jason.stephens

  Ten Centuries

  Points: 1088

  More actions

  April 22, 2008 at 7:24 am

  #123451

  Server 1 : Has a database on it with SQL 7 SP 4.

  Server 2 : We will be building with SQL 2005 SP2.

  Question: What is the best way to get the database moved? Can I just detach from Server 1 and attach to Server 2? Will the different versions of SQL be able to do that? Would I need to export and then import? The reason I ask this, besides my own lack of familiarity, is one of my supervisors has doubts about the stability of Server 1 and does not want to risk upgrading SQL on it for fear of a total crash. What is the best method for me to do?

  Thanks in advance!

• SQL ORACLE

  One Orange Chip

  Points: 27807

  More actions

  April 22, 2008 at 2:34 pm

  #805771

  You may use the same method to migrate data from SQL Server 7.0 or from SQL Server 2000. See the link below.

  http://support.microsoft.com/kb/314546