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 an information liquidity 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 target databases.
• Reverse Engineering for Replication Server
  You can reverse engineer an existing Replication Server definition into an ILM using two live connections:

---

Created October 7, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com