Create Target Table Wizard

Select Source Connection> Select Target Connection> Define Columns> SQL Script> Summary

Use this wizard to create a table in the database to which you are replicating if your target database does not already contain a table for the replicated data. Note that if source tables include constraints, and you want those same constraints on target tables, you need to create them manually at the target system once you have created the tables.

Select Source Connection

This screen lists all the source connections that you have created in Syniti Data Replication.

Source Name

Choose a source connection name from the drop-down list.

Source Table

Choose a source table from the drop-down list.

Open Table

Opens the Execute SQL Command dialog that displays the contents of the source table for your review. Note that if you execute a SQL query from this dialog, it does not affect any source, target or replication settings.

Select Target Connection

This screen lists all the target connections that you have created in Syniti Data Replication.

Source Name

Choose a target connection name from the drop-down list.

Source Table

Type a name for the table that will be created.

Open Table

Define Columns

Displays the column and column information that will be created on wizard completion. Edit column information by clicking on cells.

NOTE: The Identity field should be checked for a row if the source table has this column as an Identity field and the Identity status should be maintained when creating the target table. The Identity field is disabled for non-numeric columns. This behavior is managed in the Target Connection Properties, using the property CREATE TABLE Keep Identity which is set to True by default. If set to False, the Identity fields(if any) in the source table will not be marked as Identity in the target table.

You can add and remove columns and primary keys using either the toolbar icons or the right mouse button menu. The available options are:

Insert Field Before

Select a field and choose this option to create a new field above this one.

Insert Field After

Select a field and choose this option to create a new field after this one.

Delete Field

Select a field and choose this option to remove the column from the table.

Set Primary Key

Select a field and choose this option to make the column a primary key. Note that primary keys can be set only on columns that cannot have a null value.

Delete Primary Key

Select a field and choose this option to delete a primary key setting.

SQL Script

Displays the SQL script that will be used to generate the target table based on the information from the source table and any changes you have made in the Define Columns screen. You can edit the SQL script as needed. Be sure to follow standard SQL syntax that can be used with your database system.

Summary

Displays the settings for creating a target table.

Create another table

Opens the Create Target Table wizard on completion of the current wizard.

Proceed with the definition of a replication

Opens the Replication wizard on completion of the current wizard.

Opening the Create Target Table Wizard

In the Management Center Metadata Explorer, select a source table.
From the right mouse button menu, choose Replication, then Create Target Table.