Starting Data Replication

You can create and run replications from source to target data stores.

Starting your replication

To start Data Replication:

  1. Create a project.

  2. From the Assets tab of your project, click New asset > Replicate data.

  3. Enter a name.

  4. The Copy business goal is already selected for you. Copy will synchronize the specified schemas and tables from the source to the target. Click Source options.

  5. Select a source connection from the list, or click Add Connection to create a new one. For more information on how to set up each type of connection, see Supported Data Replication connections.

  6. Click Select data.

  7. Select a schema to see the list of tables for that schema. You can select one or more schemas and tables.

    Selecting only a schema without selecting any tables in the schema will keep the schema (and all its tables) from the source synchronized on the target. An asterisk will be added next to the schema in the Replication selection column to indicate that the entire schema will be replicated.

    If you select one or more specific tables from a schema, then only those tables will be synchronized. The tables will be listed in the Replication selection column and you can expand and collapse the schema to see the set of selected tables from that schema.

  8. Click Target options.

  9. Select a target connection from the list, or click Add Connection to create a new one. For more information on how to set up each type of connection, see Supported Data Replication connections.

  10. Click Review.

  11. Review the summary, then click Create.

Running your replication

To run your replication:

  1. From the project, click the Assets tab.
  2. Click the Data Replication asset.
  3. Choose the Data Replication service instance that you want to use to run the replication job from a drop-down list that contains the service instances you can access.
    Note: The Data Replication service instance that is created when the service is installed is only accesible to users with Admin access to the project. If you do not have access to any replication service instances, you can create a new replication service instance or request the Cluster Administrator to grant you access to existing service instances.
  4. Click the Run replication icon Run replication to start the replication process.

The replication status changes to Starting and you can see progress in the event log. The status changes to Running after the replication process starts.

Data replication continues until you stop the process manually. Changes to the selected source schema tables are replicated in the target database tables.

Learn more

Parent topic: Replicating data with the Data Replication service