Upgrading OLAP Metadata Catalogs Manually

If you have OLAP Metadata Catalogs from an earlier release of Integration Services and you choose not to use the automatic creation-upgrade process, you must upgrade the existing OLAP Metadata Catalogs manually. You cannot use the existing catalogs with the new release of Integration Services until the catalogs are upgraded.

Note:

If you use Integration Services Console to create an OLAP Metadata Catalog automatically, the system upgrades existing OLAP Metadata Catalogs and you do not need to upgrade them manually (see Creating or Upgrading OLAP Metadata Catalogs Automatically). recommends that you use the automatic process to create the OLAP Metadata Catalog.

You manually upgrade the tables of an OLAP Metadata Catalog by running the SQL scripts that use the same database utility program that you typically use to create tables. The SQL scripts to upgrade tables for the OLAP Metadata Catalog are in the ocscript directory where you installed Integration Services. The upgrade scripts are named oc_upgrade*_ database_name.sql and are listed in Table 1, SQL Scripts for Creating an OLAP Metadata Catalog, along with the utility programs with which they have been tested.

Note:

If you manually rebuild an OLAP Metadata Catalog, you must drop (delete) the catalog tables by using oc_drop*database_name.sql. Then you create the OLAP Metadata Catalog tables by using oc_create*database_name.sql. If you choose to rebuild a catalog manually, it is not necessary to run any upgrade scripts.

Caution!

If you drop (delete) an OLAP Metadata Catalog, you also delete the OLAP models and metaoutlines that it contains.

The following topics discuss various aspects of upgrading OLAP Metadata Catalogs manually: