Setting Up a Replication

With Syniti Replicate, there are just a few steps involved in setting up a quick test replication. When you have tried everything out, you can explore the different options that Syniti Replicate has to offer, including setting up multiple replications simultaneously, performing synchronization between two or more systems, customizing replications with mapping and/or scripts and so on.

Here's how to get started.

  1. Decide what type of data replication you want to perform.

    Refresh

    Copy entire data set from source to target once only

    Continuous Refresh

    Copy entire data set from source to target according to a schedule

    One-way mirroring (with or without initial refresh)

    Initially copy entire data set from source to target, then copy only changes from the source to the target database according to a schedule. This approach is also known as Change Data Capture.

    Synchronization (with or without initial refresh)

    Initially copy entire data set from one system to the other, then keep changes to the two databases synchronized according to a schedule

Click on one of the links above for detailed steps on how to create a replication, or use the overview below to guide you.

  1. Using the Management Center, create a connection to the source database table(s).

  2. Create a connection to the target database table(s).

  3. For mirroring or synchronization, use the Enable Transactional Replication wizard to set up access to the database log.

  4. Set replication properties using the Replication wizard or the Multiple Replications wizard.

  5. Enable the replication(s).

  6. Start the Replication Agent using the Service Monitor in the Windows Notification Area.