SQL Optimizer for Oracle 10.0 - Installation Guide

Upgrade SQL Optimizer

To upgrade from a previous version of SQL Optimizer

To perform a standard upgrade from a previous version of SQL Optimizer, follow the instructions in the previous section "Install SQL Optimizer". For side-by-side installation or to upgrade from a 32-bit version to a 64-bit version (or vice versa), see the following special instructions.

Side-by-side installation

SQL Optimizer supports side-by-side installation. If you have a previous version of SQL Optimizer installed, when you run the installation program for the current version, you can either install the upgrade into the existing directory or you can install it into a new directory to have both versions installed side-by-side.

To upgrade from a 32-bit version to a 64-bit version (or vice versa)

Starting with release 8.7, SQL Optimizer is available in a 32-bit version and a 64-bit version.

SQL Optimizer 8.7 (or later) does not support an upgrade from the 32-bit version to the 64-bit version (or 64-bit to 32-bit). To upgrade to a newer version of SQL Optimizer that has a different "bitness" (i.e., from 32-bit to 64-bit, or from 64-bit to 32-bit), you must first uninstall the previous version.

Note: SQL Optimizer 8.7 (or later) supports side-by-side installation of versions with different "bitness" as long as they are also different releases (for example, 8.6 and 8.7) or different editions (for example, Commercial and Trial, or Trial and Beta).

To upgrade from SQL Tuning for Oracle

If you are upgrading from SQL Tuning for Oracle 6.1.2 or earlier, SQL Optimizer requires a full installation.

Uninstall SQL Optimizer

To uninstall SQL Optimizer

1. Uninstall SQL Optimizer using your Windows add/remove programs feature.
2. For example, in Windows 7, select Control Panel | Programs | Programs and Features | Uninstall a program.
3. Select SQL Optimizer for Oracle (the version or edition that you want to uninstall).

4. Click Uninstall.

Configuration

Start SQL Optimizer

To start SQL Optimizer

• Select Start | All Programs | Quest Software | SQL Optimizer for Oracle | SQL Optimizer version for Oracle.

Note: When installed as part of a Quest Software suite, SQL Optimizer is located within the suite root folder.