Cleaning up the Database Schema
Use the DDL Script Generator utility to generate scripts to clean up the database.
- Procedure
- On the machine that runs ActiveMatrix Administrator, configure the drivers for the database by using the TIBCO Configuration Tool.
- Navigate to the
TIBCO_HOME
/administrator/<version>/samples/ddl folder. - Edit the
generate_ddl.xml
file and modify thedbType
anddialect
for your database type under thedrop
target. For more information, see DDLGeneratorTask.<target name="drop"> <DDLGeneratorTask action="drop" targetDirectory="${admin.ddl.samples.directory}" dbType="oracle11g" dialect="com.tibco.amf.sharedresource.runtime.core.hibernate. dialects.Oracle10gDialect" /> </target>
- Run
ant -f generate_ddl.xml drop
. - Depending on what portions of the schema you want to remove, have the DBA execute the script files -
drop_*.ddl
in the corresponding databases as explained in the Database Models section. - (Optional) In addition to the generated scripts, if you want to use the Monitoring service, the DBA needs to execute an additional script corresponding to the monitoring data. It can be found under
<TIBCO_HOME>/administrator/<version>/scripts/governance/ddl/drop_*.sql
. Use the script corresponding to your database type.