Mapping a single temporal table where the source datastore manages the history

You can use a wizard to map a single temporal table, where the source datastore manages the history.

1. Click Configuration > Subscriptions.
2. Select the subscription and ensure that it has been defined so that the source datastore manages the history.
3. Right-click and select Map Tables.
4. Select Custom Table Mapping > Standard and click Next.
5. Determine the type of tables to be mapped. Select a table type and click Next:

   Map Tables With History

   Specifies that the list of source and target tables available for mapping will be filtered to include only system temporal or bitemporal tables. The subscription will automatically replicate history for the source tables.

   Map Tables Without History

   Specifies that the list of source and target tables available for mapping will not be filtered and will include all source tables. However, you may only map to tables on the target that are not system temporal or bitemporal, as you cannot map non-temporal source tables to temporal target tables.

6. Expand the database, schema, or table from the Source Tables list to view tables from your database that are available for mapping. Right-click the database user or schema and click Refresh if you do not see your table listed.

   You may be prompted to filter databases, schemas, or tables if Automatically prompt for filter when expanding nodes is enabled in your preferences. For more information see, Setting advanced preferences. To manually define a filter, select a datastore, database, or schema and click Specify Filter.

7. Enable the table to map from the Source Table list. If you do not see your table listed, right-click the database user or schema and select Refresh.
8. If you want to hide columns so that the target is not aware of them, select a source table and click Filter Columns. Clear the check box for the column you want to hide and click OK.
9. Click Next.
10. Expand the database, schema, or table from the Target Tables list to view tables from your database that are available for mapping. Right-click the database user or schema and click Refresh if you do not see your table listed.
11. Choose one of the following and click Next:

    Use an Index

    Select the index name from the box or select <Auto Detect> if you want CDC Replication to automatically choose the index. Use if your target table has an index that uniquely identifies a row.

    Use all searchable columns

    Searches all target columns to identify which columns are suitable to uniquely identify rows. The results of the search are used to build a WHERE clause which uniquely identifies the row on the target column to apply data.

    Specify the key

    Select the target columns from the Key Columns list. Use if one or more target columns uniquely identifies a row.

12. Choose a replication method from the following and click Next:

    Mirror (Change Data Capture)

    Immediately replicates changes made to the source table to the target table or accumulate source table changes and replicate at a later time. If your configuration requires you to prevent recursive updates when mirroring, enable the Prevent Recursion check box. This check box is only available in components of CDC Replication that support both source and target databases.

    Refresh (Snapshot)

    Replicates a snapshot of the source table to the target table.

13. Click Next.
14. Review the mapping summary.
15. Choose one of the following options and click Finish:

    Define column mappings

    Continues with the column mapping.

    Create a new table mapping

    Allows you to start a new table mapping.

    Return to current view

    Returns you to the current view.