Upgrade Guide › Upgrading Databases › Upgrading the Data Warehouse

Upgrading the Data Warehouse

When you upgrade your CA DataMinder data warehouse, you can choose a fully automated upgrade, or you can customize the upgrade using Native Upgrade scripts provided by CA DataMinder.

Fully Automated Upgrade

You upgrade your data warehouse at the same time as you upgrade your CMS.

1. Run setup.exe on the server hosting the CMS and data warehouse.

   Find this file in the root of the CA DataMinder distribution image.

   CA DataMinder automatically detects that you are upgrading and launches the server installation wizard.

2. Follow the on-screen instructions. Continue to the final wizard screen and click Install.

Native Script Upgrade

(Oracle data warehouses only) If you prefer to upgrade your data warehouse by running native scripts, follow these steps:

1. Run a native script to upgrade the data warehouse tables.
2. Upgrade the data warehouse:
   1. Run setup.exe on the server hosting the CMS and data warehouse.

      Find this file in the root of the CA DataMinder distribution image.

      CA DataMinder automatically detects that you are upgrading and launches the server installation wizard.

   2. Follow the on-screen instructions. Continue to the final wizard screen and click Install.
3. (Optional) Partition the new data warehouse tables that were added in the current CA DataMinder release.

Steps 1 and 3 are described in the following sections.

More information:

Run a Native Script to Upgrade the Data Warehouse

Partition the New Data Warehouse Tables