Example: Data Model

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:

Technical System Landscape