Siebel Database Upgrade Guide for DB2 for z/OS > Preparing Data for a Siebel Migration >

Creating Migration Rules

For migration, the Migration Input (INP) file and the Transformation (RUL) file are the input files required to do the initial data export and import of data. For more information about the INP and RUL files, see About Siebel Rules Expression Designer.

After you create your migration rules and export them, the datamig.inp file is generated and the datamig.rule file is generated only if you select an Update Action during the process of creating your rules with the Expression Designer.

This procedure describes how to create a migration rule using the Migration Rules Expressions Designer.

To create a migration rule

1. Navigate to Site Map, then Administration - Application, then Migration Rule.
2. In the Migration Rule Expressions applet, click New.
3. Click the icon next to the Table column.
4. Select the table to migrate the data from the source environment to the target environment.
5. To migrate only selective data from the table, perform the following steps:
   1. Click the icon next to the Condition column.
   2. In the Expression Designer, the Table Category is automatically selected.
   3. Select items in Sub Categories. Column names appear in Elements that match the selected subcategory.
   4. Choose the appropriate column name in Elements and click Add Element.
   5. Enter a value to filter the data.
   6. Click Validate and verify there are no syntax error in the Expression.
   7. Click Save.
6. To transform only the data on selective columns when migrating the data from the source environment to the target environment, perform the following steps:
   1. Click the icon next to the Update Action field.
   2. Select the appropriate column and the value.

      The values assigned to the columns chosen will be updated on the target environment regardless of the value specified in the source environment.

7. Select the Select Flag.
8. Click Save.
9. To add another table, repeat steps 1-8.
10. Once you add the records for all the tables that you wanted, click Export.

    Once the data is exported, the datamig.inp file and the datamig.rul file are generated.