Mapping using standard replication

If you want your target table to keep an updated image of the data contained in the source table, then map your source and target tables using standard replication.

Your source and target tables can be of different types and you can transform the data that you replicate between the source and the target. Under standard replication, CDC Replication applies the same operation that occurred on the source table to the target table. A row insert operation on the source table determines a row insert operation on the target table, and so on. You can map tables one at a time using standard replication.

Management Console provides two mechanisms for mapping:

Multiple one-to-one table mappings: Map tables using one-to-one replication when you want to map multiple source tables to multiple target tables at a time and these tables share the same table structure and similar table names.; The Map Tables wizard automatically maps tables based on an example mapping you set up.
Custom table mappings: Map tables using custom replication when you want to map only one source table to one target table at a time. Use custom table mappings when you need more control over the way the table is mapped.; For example, use custom mappings for tables that do not share the same table structure or similar table names, for mappings where you need to filter out columns for a particular table, or for tables where you want to pick a particular index.