Working with Replication Server

Replication Server is a relational database replication engine which helps you to replicate data from a primary database to one or more replicate databases. PowerDesigner supports modeling for Replication Server version 12.5 and higher, including round-trip engineering.

The following example shows a data movement diagram representing a replication of data from a source database to two remote databases, each of which are modeled in Physical Data Models (PDMs):

• Modeling for Replication Server
  PowerDesigner supports the modeling of all the components required to deploy a Replication Server solution in your environment.
• Generating for Replication Server
  You can generate Replication Server scripts (*.sql) for the replication process, and/or for the primary and remote databases.
• Reverse Engineering for Replication Server
  You can reverse engineer an existing Replication Server definition into a DMM using one live connection for the consolidated database and one for the remote database.