Migration Tool Configuration File

The Migration Tool configuration file, initially named migrationTool.xml, stores database connection configuration (excluding passwords), object filter, and object exclude details you enter through the Migration Tool. The following sample Migration Tool configuration script, called migrationTool.xml, includes the database connection details for two data sources (one called PROD and one called QA), the <filter> tag for the filter that is being applied to the EMPLOYEE table, and the <exclude> tag to exclude the Activities functional object from the Select Tables/Functional Objects page. 

<?xml version="1.0" encoding="UTF-8"?>
<migrationTool>

<options>
<transactionScope commit='OBJECT'/>
</options>

<datasources>
<datasource name='PROD'>
<driver-class>com.ibm.db2.jcc.DB2Driver</driver-class>
<driver-url>jdbc:db2://aixdb03:50000/RDWB15PR</driver-url>
<username>wrkbrain</username>
</datasource>

<datasource name='QA'>
<driver-class>com.ibm.db2.jcc.DB2Driver</driver-class>
<driver-url>jdbc:db2://aixdb03:50000/RDWB15QA</driver-url>
<username>workbrain</username>
</datasource>
</datasources>

<filters>
<criteria name='EMPLOYEE' type='TABLE'><![CDATA[EMP_ID < 5000]]></criteria>
</filters>

<exclude>
<functionalObject name='Activities'></functionalObject>
</exclude>

</migrationTool>

For more information about:

When you exit the Migration Tool, you will be prompted to save any changes to the configuration file upon exit. Whenever the Migration Tool is loaded, it automatically retrieves the information that was last saved to the migrationTool.xml file and auto-populates the tool with these database definitions, filters, and table or functional object exclude details.

By default, the Migration Tool points to the migrationTool.xml configuration file, which is created when you save your Migration Tool configurations for the very first time. This file is saved to the base path from where the Migration Tool is running and can be renamed to any name of your preference. When you re-save your configuration settings upon exiting the application, you can save the file with a completely new name; the Migration Tool will then automatically reference the new file. Therefore, you can actually have multiple configuration files.

To verify which configuration file the Migration Tool is referencing, or to point the Migration Tool to a different configuration file, select Administration > Change Configuration Settings. You will see the filename in the Configuration File field.

For more information about the Change Configuration Settings feature, see Change Configuration Settings.