Post reply

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

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

     

     

  • 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

  • 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

  • June 15, 2005 at 1:47 am

    #565568

    and last but not least

    (8) reserve lots of time

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

Viewing 5 posts - 1 through 4 (of 4 total)

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