How to Change Schema Initialization Options

While commonly used schema options within CopyStorm are directly exposed in the CopyStorm GUI, a number of schema initialization parameters can only be provided by providing CopyStorm with a JDBCDatabaseBuilderConfig.xml file.

To use the options detailed in this page, create a JDBCDatabaseBuilderConfig.xml file and copy it to one of the CopyStorm Configuration File Directories.

Capitalize Column & Table Names

The following XML will cause CopyStorm to create a Salesforce data table and column names in ALL CAPS.

<JDBCDatabaseBuilder>
<!-- 
    Set these values to "true" to capitalize table and column names.
-->
	<CapitalizeTableNames enabled="true" />
	<CapitalizeColumnNames enabled="true" />

</JDBCDatabaseBuilder>

Remove Table & Column Postfixes

The following XML will cause CopyStorm to remove Salesforce-standard postfixes from database table and column names.

<JDBCDatabaseBuilder>
<!--  
    Remove the following postfixes from Salesforce data tables and columns
-->
	<RemovePostFixFromTableName postfix="__c,__ka,__kav,__b,__x" />
	<RemovePostFixFromColumnName postfix="__c" />
</JDBCDatabaseBuilder>