How to perform a SQL Server version 6.5 to SQL Server 2000 upgrade using a tape drive (SQL Server Upgrade Wizard)

SQL Server Setup Help

SQL Server Setup Help

How to perform a SQL Server version 6.5 to SQL Server 2000 upgrade using a tape drive (SQL Server Upgrade Wizard)

Note  To run the SQL Server Upgrade Wizard, you must have an instance of Microsoft® SQL Server™ 2000 already installed on your computer.

To perform a SQL Server version 6.5 to SQL Server 2000 upgrade using a tape drive

  1. On the Start menu, point to Programs/Microsoft SQL Server-Switch, click SQL Server Upgrade Wizard, and then click Next.

  2. In the Data and Object Transfer screen, click Tape, and then click Next. Verification options are recommended, but not required. Click Help for information.

  3. On the Logon screen, in the Server name box in the Export server (6.5) group box, enter the name of the computer on which Microsoft SQL Server version 6.5 is installed.

    In the Administrator password ('sa') box, enter the sa password for SQL Server 6.5, and then click Next.

    Unless you have changed it, the sa password for SQL Server 2000 is blank.

    For Import Server (2000), the server name is filled in. Enter optional startup arguments, if you want. Click Help for information. When you are finished setting options, click Next.

  4. In the message box asking if you want to continue, click Yes if you are ready to upgrade. The SQL Server Upgrade Wizard switches to the SQL Server 2000 server.

  5. In the Code Page Selection screen, accept or change the default settings, and then click Next.

  6. In the Database Selection screen, include the databases to upgrade. Move any database not to be upgraded at this time to the Exclude list, and then click Next.

  7. In Device for data transfer, specify the location of the tape drive.

  8. In 6.5 device backup options, select Backup 6.5 devices before exporting data if you have not backed up the databases already.

    Prior to creating the SQL Server 2000 databases, the SQL Server Upgrade Wizard either prompts you to back up the SQL Server 6.5 devices or copies the devices for you automatically.

  9. Select Delete 6.5 devices before importing data if necessary due to lack of disk space, and then click Next.

    After objects and data are exported, and before creating databases in SQL Server 2000, the SQL Server Upgrade Wizard deletes the SQL Server 6.5 devices to reclaim disk space.

  10. Select Use the default configuration or edit the default, and then click Next.

    Click Edit to examine and make changes to the proposed disk configuration within the layout utility. In the Proposed Database Layout box, make changes as needed. Click Advanced to view Object Details and Drive Summary. When you are finished, click Accept to return to the SQL Server Upgrade Wizard.

  11. In System objects to transfer, select the object types to transfer from SQL Server 6.5 to SQL Server 2000:
    • Server configuration

      Login and remote login registrations and server configuration options relevant to SQL Server 2000 are transferred as part of the version upgrade.

    • Replication settings

      All articles, subscriptions, and publications of each selected database, plus the distribution database, if any, are transferred and upgraded.

    • SQL Executive settings

      All tasks scheduled by SQL Executive are transferred and upgraded so that SQL Server 2000 can schedule and run those tasks in SQL Server Agent.

  12. In ANSI Nulls, select:
    • Off, if ANSI nulls should not be used when stored procedures are created. This is the default.

    • On, if ANSI nulls should be used when stored procedures are created.
  13. In Quoted Identifiers, select one of these options, and then click Next:
    • Mixed (or don't know), if some of your objects were created with QUOTED_IDENTIFIER set to ON and others with it set to OFF, or if you are not sure how they were created.

    • Off, if all objects should be compiled with QUOTED_IDENTIFIER set to OFF.

    • On, if all objects should be compiled with QUOTED_IDENTIFIER set to ON.
  14. In the Completing the SQL Server Wizard screen, view the summary of choices you have made. Click View warnings and choices in notepad to open a text version of the upgrade script. If all options are correct, click Finish.

    The SQL Server Upgrade Script Interpreter screen appears with information about the progress of the upgrade.

See Also

Order of Upgrade Using a Direct Pipeline or Tape Drive