In the <Table_Name> - Table Settings window, you can define how the data for each individual table/view is replicated to the target.
Some of the table settings are not available in a Log Stream Staging setup.
For information on the availability of table settings in a Log Stream Staging setup,
To open the Table Settings window:
Open the task you are working with.
For information on opening a task, see Editing a replication task.
In Designer view, select the desired table from one of the following tabs on the right of the console:
- The Patterns and Selected Tables tab - if the desired table was explicitly selected.
The Full Table List tab - if the desired table was selected using a table inclusion pattern.
For information on how to define table selection patterns, see Creating table/view selection patterns.
Click the Table Settings button above the table list.
The <Table_Name> - Table Settings window opens.
In the Table Settings window, perform any of the following tasks:
- Click OK to close the Table Settings window.
- Click Save in the main toolbar to preserve the table and column information for this task.
To restore the default table values:
Click Restore Table Defaults at the bottom left of the Table Settings window. This option is available in all tabs.
Any changes you made will be discarded and the table's default settings will be restored.
The names of modified tables will be followed by the word (changed), enabling you to easily identify which tables have been modified.