Manual Sistemas 1

Upgrading from SQL Server 7.0 to SQL Server 2000

You can overwrite an installation of SQL Server 7.0 with a version upgrade to SQL Server 2000. If SQL Server 7.0 is detected as an existing installation when you run Setup, you can choose the option to upgrade. In this process, all the SQL Server 7.0 program files are upgraded, and all data stored in SQL Server 7.0 databases is preserved. Inaddition, SQL Server Books Online for SQL Server 7.0 remains on your computer.
Note: SQL Server 7.0 profiler traces and registered servers are not upgraded when SQL Server 7.0 tools are upgraded to SQL Server 2000. Similarly, information models that were installed with Microsoft Repository 2.0 are not upgraded automatically. SQL Server 2000 supports newer versions of information models for both DataTransformation Services (DTS) and the Open Information Model (OIM).
You can also upgrade from one edition of SQL Server to another edition during the version upgrade to SQL Server 2000.
Caution: After you perform this version upgrade, the SQL Server 7.0 installation no longer exists on your computer. The only way to restore an installation of SQL Server 7.0 is to first uninstall SQL Server2000, perform a complete reinstall of SQL Server 7.0 files, and then restore your backed-up SQL Server 7.0 databases.

Upgrading During Installation

|1. |Insert the SQL Server 2000 compact disc for the edition to which you want to upgrade into your CD-ROM drive. If the |
| |compact disc does not autorun, double-click Autorun.exe in the root directory of the compact disc.|
| |Note: If you have purchased an edition of SQL Server with more features than your current SQL Server 7.0 installation, |
| |the upgrade process will perform both the version and edition upgrade at the same time. |
|2. |Select SQL Server 2000 Components, and then select Install Database Server.Setup then prepares the SQLServer |
| |Installation Wizard. At the Welcome screen, click Next. |
|3. |In the Computer Name dialog box, Local Computer is the default option and the local computer name appears in the edit |
| |box. Click Next.|
|4. |In the Installation Selection dialog box, click Upgrade, remove, or add components to an existing instance of SQL |
| |Server, and then click Next. |
|5. |In the Instance Name dialog box, Default will be selected. Click Next.|
| |Note: When upgrading, SQL Server 7.0 automatically becomes the default instance of SQL Server 2000. |
|6. |In the Existing Installation dialog box, click Upgrade your existing installation, and then click Next. |
|7. |In the Upgrade dialog box, you are prompted as to whether you want to proceed with the requestedupgrade. Click Yes, |
| |upgrade my to start the upgrade process, and then click Next. The upgrade runs until |
| |finished. |
|8. |In the Connect to Server dialog box, select an authentication mode, and then click Next. ||9. |If you are not sure which mode to use, accept the default: The Windows account information I use to log on to my |
| |computer with (Windows). |
|10. |In Start Copying Files dialog box, click Next. |...