Move SQL 6.5 server from old computer to new computer with SQL 2000

• Paul Hoang

  SSC Rookie

  Points: 45

  More actions

  June 13, 2005 at 12:23 pm

  #109732

  Hello,

    I am planning to move old computer run windows NT 4.0 with SQL 6.5 to new server run Windows 2003 with SQL 2000.

  I have built new server that  is running Windows 2003, SQL 2000 now I am stumps and don't know what are steps how to move database, please help.

   

  Thanks you, all.

   

   

• Janne-232659

  SSC Rookie

  Points: 34

  More actions

  June 14, 2005 at 1:27 am

  #565182

  Books on line: Installing SQL Server / Upgrading Databases from SQL Server 6.5

  use upgrade wizard, ...\MSSQL\upgrade\upgrade.exe

• Jimmy Jen

  SSCrazy

  Points: 2915

  More actions

  June 14, 2005 at 12:29 pm

  #565438

  I haven't done this before, but Brian Knight's book "Admin 911 SQL Server 2000" recommends the following steps:

  (1) Check the hardware installtion requirements

  (2) Install SQL Server 6.5 SP4

  (3) Make sure TempDB is at least 25MB

  (4) Install IE 4.0 or greater

  (5) Run SQL Server Upgrader Wizard to upgrade the 6.5 databases and users

  (6) validate the data

  (7) remove SQL Server 6.5 when you feel comfortable with the data

• JP de Jong-202059

  SSCommitted

  Points: 1674

  More actions

  June 15, 2005 at 1:47 am

  #565568

  and last but not least

  (8) reserve lots of time

• swede

  SSCommitted

  Points: 1773

  More actions

  June 15, 2005 at 10:21 am

  #565778

  not sure this is best way to do it...but I have successfully ported our database over by.

  1. create the logins in the new server

  2. create the database on the new server

  3. use an dts to copy the tables over from the old 6.5 server to the new sql2000

  4. if you had any indexes you would have to recreate.