The following
example is based on the tables in the SQL Tutorial, see SQL
Tutorial, SQL Statements for the
HOTEL Schema.
After you have installed the Synchronization Manager, go to the directory <independent_program_path>\app\syncman\example\doc for a description of a detailed example.
See
also Installation Manual, Directories.
The synchronization involves the master instance DBMASTER and the client instance DBCLIENT.
Defining the Synchronization
Database Instance |
DBMASTER |
DBCLIENT |
Replication Unit |
masterunit1 Type: IN/OUT |
clientunit1 Type: IN/OUT |
Schema.Table |
HOTEL.CITY (Master table) |
MONA.TOWN (Client table) |
Table columns |
ZIP NAME STATE |
ZIP TNAME TSTATE |
Primary key column |
ZIP |
ZIP |
Columns to be synchronized |
NAME STATE |
TNAME TSTATE |
See also: