Chapter 3 Building Information Liquidity Diagrams

Replication Processes (ILM)

A replication process is a server engine that copies data from a given database into one or more databases or replication processes.

In the following example, EUR_Replication Process copies data contained in World Source Database into Paris_Replication Process, which in turn copies data into Finance Remote Database and HR Remote Database:

You can right-click a replication process and select Replication Wizard to replicate database objects from a source database to one or more remote databases. See Replicating Objects with the Replication Wizard.

The replication process can contain the following main items:

Publications – Specifies a set of data to replicate, and from where it was extracted. Publications contain articles that correspond to the tables of the replicated database and, which point to the tables of the source database. Articles contain columns that give details on replicated columns. For more information, see Publications (ILM).
Subscriptions – Specifies where the data is replicated by indicating which replicated database subscribes to which publication. For more information, see Subscriptions (ILM).
Users – Specifies who is involved in the replication process. For more information, see Users (ILM).
Connection groups – Specifies a logical group for database connections. For more information, see Data Connection Groups (ILM).
Event scripts – Specifies how events on the process are implemented. For more information, see Event Scripts (ILM).