The scripts used to upgrade OLAP Metadata Catalog manually from Release 2.0 to Release 6.2 are identical to those used to upgrade from Release 2.0 to Release 6.1. Therefore, the names have not been changed from the names used in Integration Services Release 6.1. If you are upgrading OLAP Metadata Catalog from Release 2.0 to Release 6.2, use the scripts named *61*.sql that are appropriate for your RDBMS.
Integration Services provides five SQL scripts for each RDBMS (with the exception of Teradata):
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.2 (does not apply to Teradata users)
oc_upgrade65_database_name.sql to upgrade tables from Integration Services Release 6.1 or 6.2 to 6.5
oc_upgrade651_database_name.sql to upgrade tables from Integration Services Release 6.5 to 6.5.1
If you need to rebuild tables, you must first drop the tables before you build them again.
You must create the tables for the TBC_MD database as user TBC or portions of the standard sample application will not work.
To create tables for the TBC_MD database:
Start the utility program.
Connect to the TBC_MD database as user TBC.
In the ocscript directory, open the appropriate SQL script file.
Run the SQL script.
Microsoft SQL Server: You receive a message that you did not create data or rows. This message is normal because you created only tables and columns.
Verify that you have created the TBC_MD tables; for example, type the following command:
SELECT * FROM TBC.MS_INFO
or start the RDBMS and verify that the TBC_MD database has the new tables.