Defining Multiple Table Replications

If you need to replicate all or many of the tables in one database to another database, you can define the replications using the Multiple Replications wizard. This allows you to set the source database, target database and scheduling details just once for all replications involved. The wizard also creates tables in the target database if necessary. While the replications are scheduled to run together, you can optimize performance by first creating a group for the replications.

Follow the steps below to create a group then create multiple replications.

In the Management Center Metadata Explorer, select a metadata.
For this metadata, create a source connection and a target connection for the databases you are using in the replication.
Select the Groups item.
From the right mouse button menu, choose Add New Group.
In the Replication Group Wizard, enter a name and, optionally, a description for the group.
Click Next to display the Select Replications screen.
Click Next to go to the Summary screen right away.
Click Finish to create the group.
In the Metadata Explorer, select the source connection to the database that you want to replicate.
From the right mouse button menu, choose Create Multiple Replications.
In the Define replication type screen, enter a base replication name to identify the table replications that will be created at the end of the wizard. Each table replication will have the base replication name followed by a sequential number to identify it.
Check the Use Group option.
From the drop-down list, select the group you created above.
Choose the type of replication you want to perform.
Click Next to go to the Select source connection screen.
Make sure that the correct source connection is selected.
Click Next to go to the Select target connection screen.
Select a target connection.
Click Next to go to the Set replications screen.
All tables in the database are automatically selected for replication.
If you do not want to replicate all tables, double-click in the check box next to each table that you do not wish to replicate. This will remove the check mark.
By default, source table fields are replicated to fields of the same name in target tables.
If you wish to change the source table field - target table field mapping, click in the right column of the table containing the field.
In the Fields Mapping dialog, set the mapping to a field, an expression or no corresponding target.
Click OK in the Fields Mapping Dialog.
Click Next to go to the Scheduling screen.
Note that if Enable Replications is checked and you are running the Replication Agent as a service, the replications will start automatically after they have been created at the time you have specified. If you want to hold off on running the replications, uncheck the Enable Replications checkbox.
Set the schedule for all replications that have been defined.
Click Next to go to the Summary screen.
Review your settings, then click Start to create the replications.
Click Finish to close the wizard.
Check that all replications have been created in the Metadata Explorer by expanding the Replications node.

When you have completed the wizard, you will see that a replication has been created for each table that you selected in the wizard. The replication properties are set so that the replications will occur at the same time and within a single group.