Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002
    Posts
    6

    Exclamation Unanswered: HELP:) Upgrade / Migrate 6.5 to 2000 on new machine

    Just want to run this by you guys for input. Ive never done this.

    I will be upgrading server hardware and operating system as well as sql version.

    Old machine (sourceserver)
    PIII, NT4 Server, MSSQL 6.5 SP5a

    New machine (targetserver)
    P4 W2K ADV SERVER SP2, MSSQL 2000

    Here is what Im planning:
    SOURCESERVER
    Backup all databases including master
    Install instance of SQL2000
    Use wizard to upgrade databases
    Export all 2000 databases including master migrate to temp directory on targetserver

    TARGETSERVER
    Install 2000 ADV server (Active Dir) (same machine name as old sourceserver)
    SP2 (is there any issues with SP3?)
    MS SQL 2000
    Restore all databases

    Will this work or have I missed anything?
    Will I need to mess with ODBC / DSN ??

    This db is utilized by IIS on the same machine using ASP ADO. So it will also be an upgrade for IIS.

    Bring on the horror stories!!!! I need to learn from your experiences and wisdom before I take the plunge.

    Thanks
    Last edited by adiazeng; 12-04-02 at 18:04.

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    You have an upgrade wizard that comes with sql server 2000 that allows you to upgrade from 6.5. There are a few preparation tasks as well - like making sure you have the correct service pack installed, backing up, verifying disk space needed, increasing tempdb ... I am going to link you to death - but this will help you prepare:

    The following is a technet online seminar:

    seminar

    The following are upgrade articles:

    article with upgrade document
    problem article

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •