Skip to main content

Selecting specific tables/views for replication

This topic walks you through selecting specific tables/views to replicate.

When you select specific tables/views, all selected tables/views are replicated in full unless you define transformations or filters for the table/view. If you need to make changes to the table/view structures in the target endpoint or if you only want to select specific columns, then you need to perform the procedures described in Defining transformations for a single table/view and Using filters respectively.

  1. Open the Select Tables/Views dialog box.
  2. Select a Schema.

  3. Optionally, select the Use exact table name check box. This option is useful if your schema contains numerous tables as it will save you having to scroll through the entire list to find one specific table.
  4. If you selected the Use exact table name check box, type the exact name of the table you want to replicate in the Table/View field.
  5. Click Search.

    The table or tables (If you did not select the Use exact table name check box) will be shown in the search results.

  6. Select the table by adding it to the list on the right.
  7. To add additional tables from the same schema, repeat steps 3-6. To add additional tables from a different schema, repeat steps 2-6.
  8. Click OK to save your settings.
Information note

If you rename a table in the database, the Designer tab will still show the original table name. The Monitor tab, on the other hand, will show the new table name.