Previous Topic: Data Synchronization from an MDB to a Separate Target MDBNext Topic: Supported Database Scenarios

Understanding CA ITCM › Manager › Engine Concept › Data Synchronization from an MDB to a Separate Target MDB › Architecture of the Synchronization Mechanism

Architecture of the Synchronization Mechanism

The synchronization mechanism is similar to the replication mechanism used between the DSM domain manager and enterprise manager.

The synchronization is performed in one direction, from the managers to the target MDB. This means that if synchronized data is modified on the target MDB by another process, it will be overwritten the next time the synchronization method moves that particular data set from the manager's MDB to the target MDB.

The following illustration shows a special scenario where synchronization is performed from an enterprise manager and domain manager, both hosting their MDBs on Microsoft SQL Server, to one SQL Server target MDB.

Graphic showing a scenario where data synchronization is performed from a DSM enterprise and domain manager with SQL Server MDBs to one target SQL Server MDB

In another scenario, the target MDB may be based on Oracle. It is also possible to synchronize from one SQL Server MDB on an enterprise or domain manager to two different target MDBs.