Copying Replications

If you need to copy a replication (or replications) you have created, you can use one of the following options:

• Copy a replication in the same metadata, but using different connections.

• Copy one or more replications to a different metadata, for example when moving from a test to a production environment

Copying a Replication with New Connections in the Current Metadata

Use the Export Replications wizard to create a new replication based on settings in an existing replication. For example, if you have created a replication that mirrors data from Oracle to SQL Server, and you wish to mirror the same data to a MySQL database, use the Export Replications wizard to define the new target connection and copy the remaining replication information to a new replication.

1. Create the database connections that will be used for the copied replication.

2. Select the replication you want to copy.
   You can also copy a group of replications if they share the same source and the same target connections.

3. From the right mouse button menu, choose Export Replications.

4.  Follow steps in the Export Replications wizard to set new source and/or target connections for the replication.

Copying Replications to a Different Metadata

With a backup of the metadata containing the replications you want to copy, you can restore the selected replications in the desired metadata using the Custom Restore option and the Restore Metadata wizard.

1. Back up the metadata containing the replications you want to copy: select the metadata in the Metadata Explorer, then, from the right mouse button menu, choose Backup Metadata.

2. Select the metadata into which you want to copy the replications.
   If the metadata does not yet exist, click New Metadata in the Metadata Explorer to create a new metadata set.

3. From the right mouse button menu of the selected metadata, choose Restore Metadata.

4. In the Restore Metadata Options dialog, choose the Custom Restore option.

5. Follow steps in the Restore Metadata wizard to select the replications to copy.