Modifying table mappings

You may need to change your existing table mappings. For example, your business requirements may have changed, or there may be errors in previous mappings.

Procedure

  1. End replication on the subscription.
  2. If you need to modify a row or column selection expression for your source table, then you can make modifications on the Filtering tab in Management Console.
  3. If you need to add a new column to the source table, then alter the structure of the table. This task is done outside of CDC Replication.
  4. If you have altered the structure, then update the definition of the table in Management Console:
    1. Click Configuration > Datastores.
    2. Right-click Replication Tables.
    3. Expand the database user or schema until you display its tables. Tables are only available if you have created a table mapping in the Map Tables wizard.
    4. Select the table that has changed in your relational database management system and click Update.
  5. If you have set any data translations or column mappings for the target table, then CDC Replication retains these settings as previously defined. You can make modifications to these settings on the Column Mappings tab or the Translation tab in Management Console. After making the changes, click Apply.
  6. Change the replication method to Mirroring and flag the table for refresh:
    1. In the Table Mappings view, select the table mapping.
    2. Right-click and select Change Replication Method.
    3. Enable Mirroring.
    4. Select the table mapping and right-click Flag for Refresh.

Results

CDC Replication will refresh the tables before mirroring and update the target with new modifications.