To
create a Synchronous Table Replication:
Select Create from the top of the Replication page. The Create Replication window will appear.

Select Synchronous Table Replication from the menu, the Synchronous Table Replication Wizard will begin.

Click Next. The Synchronous Table Replication Wizard will appear.

Identify the source table to replicate and name the replication. Select the source table from the Table Name menu at the bottom of the window. Enter a name into the Replication Name field
Click Next. The Select Source Columns to be Replicated window will appear.

Select source columns from the source table. A list of available columns on the selected table appears on the left hand list box. Select source columns by double clicking on the column name or selecting the column and clicking the add button. The add all button can be used to add all columns to the replication. All the selected source columns will be displayed in the list box to the right. Columns can be likewise removed from the replication by double clicking on the column name or selecting the column and clicking the remove button.
Note: You must select all primary key columns from the source table for replication.
Click Next. The Where Clause window will open.

Add a WHERE condition clause to the SQL script, if desired. This is useful if you want to place constraints on the data that is to be replicated.
Note: The WHERE clause must follow proper SQL syntax. Refer to the section on Constraint Syntax at the end of chapter 4 for more information.
Click Next. The Select Destination Columns window will appear.

Add destination tables to the replication. Click Add. The Select Destination Database window will open.

You can choose to enter the destination database information from the Database Session / Link Name menu at the bottom of the page.
Click Next. The Select the Destination Table and Columns window will open.

Select a destination table from the Table Name menu. A list of available columns on the selected table will appear on the left hand list box.
Select destination columns by double clicking on the column name or selecting the column and clicking add button. The add all button can be used to add all columns. All the selected destination columns will be displayed in the list box to the right. Columns can be likewise removed from the replication by double clicking on the column name or selecting the column and clicking the remove button.
Select Next. The Data Initialization window will appear.

Select the desired options by checking the check box next to the appropriate option.
Clear Data: all data in the destination table is deleted when the replication is created.
Flush Data: copies all data that matches search criteria into the destination table.
Click Next. The Select Destination Columns window will reappear.

Click Add and repeat steps 7 – 13 if you want to add more columns, otherwise click Next.

Review the SQL script. You can edit the script manually by placing the cursor in the text field or clicking on Previous to return to prior windows. Click Finish when you are satisfied with the SQL statement. The Information dialog box appears

Click OK
Related topic: