Once you change the structure of a mapped target table
in your database, you must update the definition of the table in Management Console so
that subscriptions are aware of the new structure.
About this task
If you change the definition of a target table (add a new
column, set column constraints, or new foreign key dependencies) in
your database, then you need to update the definition of the target
table in Management Console. Management Console requires
you to update the target table so that the new structure is available
for configuration when editing your table mapping details. For example,
if you have added a new column on the target table, then you may want
to map a source column to the target column.
Procedure
- Click
.
- Select the subscription that
contains the mapped source and target tables.
- Right-click the table mapping in the Table
Mappings area.
- Select .
- Select
Update next to each table for which you want Management Console to initiate the re-add process. The re-add
process updates the metadata definition of a table so that the catalog is updated with the current
definition of the selected table.
- Click Next.
- Updating the definition of a target table affects all subscriptions
that use that table. If you want to update related subscriptions,
click Search to find the subscriptions that
use the same target table, and then select Update next
to each subscription from the search results list.
- Click End Replication on
each active subscription in the list.
- Click Next.
- Review the summary for the update and click Finish.
If you have added a new column to your target table and you
want CDC Replication to
replicate data to that column, then map a source column to the new
target column.