The Mapping Editor provides a quick and convenient way to visually create and refine data replications between source and remote databases. Each replication displays as an arrow linking source and target objects.
You must, as a minimum, have created a replication process in your DMM to create replications with the Mapping Editor. If no source and remote databases are connected to the replication process, you must specify them (see Creating a Data Connection with the Database Connection Wizard).
- Review and refine existing replications in any of the following ways:
-
Create a new replication. The replication is represented by a link joining source and target objects. You will generally perform the following types of drag and drops:
-
Drag a source table, view or procedure onto a target table, view or procedure to create any replication. Sub-objects with same name and code are also replicated.
An article or procedure for the parent replicated object is created in the properties pane, along with an article column for each replicated sub-object, and displays the details of the replication. You can delete the replication of unwanted columns.
-
Drag a source table or view column onto a target table or view column.
The source column is replicated to the target column. An article column for the replicated column is created in the properties pane, and displays the details of the replication.
-
-
Delete a replication. Select a replication link, and press Del.
-
Edit a replication properties. Double-click an article, procedure, or article column in the properties pane to open its property sheet, and edit its properties.
In the following example, the name column of the Customer table in the source database is replicated to the Customer name column of the Customer table in the remote database. The properties of the replicated column are displayed in the properties pane in the lower part of the window:
-
