Siebel Business Analytics Applications Upgrade Guide > Upgrading Siebel Business Analytics Applications > Process of Upgrading the Siebel Transactional Database Schema >
Importing the SIF File into the Siebel Transactional Database
Follow this procedure to import new schema definitions into the Siebel transactional database. This task is a step in the Process of Upgrading the Siebel Transactional Database Schema. To import new schema definitions into the Siebel transactional database
- Copy the file named SRW_OLTP_78.sif from the
SiebelAnalytics\dwrep to \tools\objects directory.
- Open Siebel Tools, and point to the development database.
- Lock the projects named: Table ETL and Table Nquire.
- In the menu, choose Tools > Import from Archive.
- Navigate to the directory containing the SIF files, and open SRW_OLTP_78.sif.
The Import Wizard—Preview screen appears.
- Click Next.
- Select the option, Merge the object definition, from the archive file with the definition in the repository, and click Next.
The Import Wizard reviews all the object conflicts between what is in the repository and what is in the SIF file.
- When the Import Wizard process is done, expand the tree under Conflicting Objects to verify the changes being applied from the SIF file to the repository. When you are done, click Next.
A warning appears:
The operation is going to modify your repository ...
- Click Yes.
- When the process is finished, click Finish.
After you import the new schema into Siebel Tools, apply the schema to the physical database. To apply schema definitions to the Siebel transactional database
- In Siebel Tools, in the Object Explorer, click the Table tab and query for S_ETL_*.
- Select all the tables in the list, and click Apply.
The Apply Schema wizard appears.
- In the Tables drop-down menu, choose Current Query. Enter the appropriate connection parameters, and click Apply.
|