Data Movement Diagram Objects

Replication process

Instance of a data replication engine that replicates data from one or more source databases to one or more remote databases. See Replication Processes (DMM).

Replication Server

Instance of a Replication Server replication engine that replicates data from one or more primary databases to one or more remote databases. This tool only displays when a Replication Server XEM is attached to the DMM. See Working with Replication Server.

Transformation process

Instance of a data movement process that models and document data transformations using Data Transformation Diagrams and Transformation Control Flow Diagrams. See Transformation Processes (DMM).

Database

Data store modeled in one or more physical data models. See Databases (DMM).

XML Document

Data store modeled in an XML model. See XML Documents (DMM).

Business process

Data store modeled in a business process model. See Business Processes (DMM).

Flat file

Text file which contains records. See Flat Files (DMM).

Server

Network device to which other objects are deployed. See Servers (DMM).

Publication

[none]

[none]

Set of tables, views and stored procedures to replicate via articles. See Publications (DMM).

Article

[none]

[none]

Table or view to replicate. See Articles (DMM).

Column

[none]

[none]

Table or view column to replicate. See Columns (DMM).

Procedure

[none]

[none]

Precompiled collection of SQL statements stored under a name in the database and processed as a unit. See Procedures (DMM).

Subscription

[none]

[none]

Request for a replication engine to maintain a replicated copy of database objects (such as tables, views or stored procedures) in a remote database at a specified location. See Subscriptions (DMM).

User

[none]

[none]

Person or group who is allowed to log onto the replication process. See Users (DMM).

Event script

[none]

[none]

Stored procedure to execute on a replication process or an article. See Event Scripts (DMM).

Data connection

Link between a database or other data store and a replication process or transformation process that specifies the way data is moved. See Data Connections (DMM).

Connection group

[none]

[none]

Set of data connections that provides a backup in case the primary database goes down. See Data Connection Groups (DMM).

Process connection

Link between two replication processes that specifies the way data is moved. See Process Connections (DMM).