SQL Scripts Used to Create and Upgrade Tables
The SQL scripts to create tables for the OLAP Metadata Catalog (listed in Table 1) are located in the ocscript directory where you installed Integration Services.
Integration Services provides SQL scripts for each supported RDBMS:
oc_create_database_name.sql to build tables
oc_drop_database_name.sql to drop tables
oc_upgrade20_database_name.sql to upgrade tables from Integration Services Release 1.x to 2.0 (does not apply to Teradata users)
oc_upgrade61_database_name.sql to upgrade tables from Integration Services Release 2.0 to 6.1 (does not apply to Teradata users)
oc_upgrade65_database_name.sql to upgrade tables from Integration Services Release 6.1 to 6.5
oc_upgrade651_database_name.sql to upgrade tables from Integration Services Release 6.5 to 6.5.1
Note: | If you need to rebuild an OLAP Metadata Catalog, you must drop (delete) the catalog tables before you build them. Remember that if you drop an OLAP Metadata Catalog, you also delete the OLAP models and metaoutlines that it contains. |
The utilities listed in Table 1 have been tested to work with the SQL scripts.
Table 1. SQL Scripts for Creating an OLAP Metadata Catalog
Database | SQL Script | Utility Program |
|---|
IBM DB2 | oc_create_db2.sql
oc_drop_db2.sql
oc_upgrade20_db2.sql
oc_upgrade61_db2.sql
oc_upgrade65_db2.sql
oc_upgrade651_db2.sql | IBM DB2 Command Center or >DB2 -tvf |
Oracle | oc_create_oracle.sql
oc_drop_oracle.sql
oc_upgrade20_oracle.sql
oc_upgrade61_oracle.sql
oc_upgrade65_oracle.sql
oc_upgrade651_oracle.sql
oc_create_oracle_unicode.sql
oc_create_oracle9i_unicode.sql | SQL*Plus |
Microsoft SQL Server | oc_create_sqlsrv.sql
oc_drop_sqlsrv.sql
oc_upgrade20_sqlsrv.sql
oc_upgrade61_sqlsrv.sql
oc_upgrade65_sqlsrv.sql
oc_upgrade651_sqlsrv.sql | Query Analyzer (Microsoft SQL Server 7.0 and 2005) |
Teradata | oc_create_teradata.sql
oc_drop_teradata.sql
oc_upgrade65_teradata.sql
oc_upgrade651_teradata.sql | BTEQ |