Defining Replication Units 

Use

You group the tables to be synchronized in logical replication units. You have to define at least one master replication unit for the master database instance and one client replication unit per client database instance.

Prerequisites

●     You have designed a data model.

●     You have defined replication tables in the master instance.

●     You have started the Synchronization Manager GUI.

●     You are logged on to the master database instance as a synchronization user.

Defining Master Replication Units

...

       1.      You are on the Replication Units tab page.

To define a master replication unit, choose Replication Units ® Add Master Unit..

Enter the following information:

Screen Field	Value
Unit Name	Name of the master replication unit
Unit Type	Type of the master replication unit

       2.      To add replication tables, select the replication unit.

Choose Replication Units  ® Add Table...

Choose the schema to which the replication tables belong.

Select the desired tables.

       3.      You can also exclude columns and column groups from the synchronization.

To exclude a column or column group, select the replication table under the Tables node.

In the Column Filter for Replication area, deselect the column or column group.

Defining Client Replication Units

Perform the following steps for all client database instances that are to be involved in the synchronization.

...

       1.      You are on the Replication Units tab page.

To define a client replication unit, select the master replication you want the client replication unit to belong to.

Choose Replication Units  ® Add Client Unit...

Enter the following information:

Screen Field	Value
Unit Name	Name of the client replication unit
Host	Computer on which the client database instance is located
Database	Name of the client database instance
User	Name of the synchronization user of the client database instance
Password	Password of the synchronization user
Save Password	Specifies whether the Synchronization Manager should save the password The Synchronization Manager saves the password in plain text.
Unit Type	Type of the client replication unit

       2.      You can also edit the synchronization properties of the client tables. This is necessary if, for example, a table in the client instance has a different name than in the master instance, or if you want to define a filter.

To edit the synchronization properties of a single client table, select that table in the Participant Tables area.

                            a.      In the Participant Tables area, select the desired client table.

                            b.      Choose Edit Table.

                            c.      Edit the synchronization properties of the client table.

Screen Field	Value
Table Schema	Name of the schema that the client table in the client instance belongs to.
Table Name	Name of the client table in the client instance
Master Column	Name of the column in the replication table in the master instance
Column Name	Column name in the client table in the client instance
Constraint Type	Type of filter condition
Constraint Value1 Constraint Value2	Filter condition values

To change the synchronization properties of multiple client tables simultaneously, select those client tables in the Participant Tables area.

...

                            a.      Choose Set Schema.

                            b.      Specify the schema that the client tables in the client instance belong to.

Result

You have defined replication units.

To use these replication units for synchronization, you have to activate them (see Activating and Deactivating Replication Units).