How can I review the database initialization scripts that the XCD installer runs to create the required user, tables, and views?
Article ID: KB0084430
Updated On:
| Products | Versions |
|---|---|
| TIBCO XML Canon | - |
| Not Applicable | - |
Description
Resolution:
To review the scripts before the database is initialized:
1. Install and configure XCD.
2. When prompted with the "Automatically initialize or update the database" message, select "No."
3. Based on the database specified for use during configuration, the scripts that XCD would have run are generated to Program Files/TIBCOExtensibility/XML Canon/Tomcat/conf/dbscripts/oracle or Program Files/TIBCOExtensibility/XML Canon/Tomcat/conf/dbscripts/sqlserver (assuming a default install path).
4. The scripts can be reviewed by a DBA at this time. The scripts can then be run manually or the configuration agent can be re-started to have the database initialized automatically.
Note: If scripts are modified, they must be run manually.
To review the scripts before the database is initialized:
1. Install and configure XCD.
2. When prompted with the "Automatically initialize or update the database" message, select "No."
3. Based on the database specified for use during configuration, the scripts that XCD would have run are generated to Program Files/TIBCOExtensibility/XML Canon/Tomcat/conf/dbscripts/oracle or Program Files/TIBCOExtensibility/XML Canon/Tomcat/conf/dbscripts/sqlserver (assuming a default install path).
4. The scripts can be reviewed by a DBA at this time. The scripts can then be run manually or the configuration agent can be re-started to have the database initialized automatically.
Note: If scripts are modified, they must be run manually.
Issue/Introduction
How can I review the database initialization scripts that the XCD installer runs to create the required user, tables, and views?
Environment
Product: TIBCO XML Canon
Version: 1.2
OS: All
--------------------
Feedback
Yes
No
Powered by
