PowerDesigner supports the modeling of all the components required to deploy a Replication Server solution in your environment.
The PowerDesigner ILM provides support for the following network components when modeling a Replication Server environment:
Replication Servers – coordinate the data replication activities for the local data servers and exchange data with Replication servers at other sites. PowerDesigner models replication servers as replication processes (see Replication Processes (ILM)) with a Replication Server type and additional properties (see Replication Server Properties).
Primary and Replicate databases – contain data that will be replicated and receive replicated data respectively. The structure of each database is modeled in an attached PDM. PowerDesigner models databases in a Replication Server environment as standard databases (see Databases (ILM)) with additional properties (see Replication Server Database Properties).
Servers – provide a logical location for replication servers and databases. You should associate all of your network components to appropriate servers to ensure correct script generation and a model check is used to verify that each component is associated to a server (see Servers (ILM)).
Network components are connected via the following kinds of data connections:
Connections– specify a message stream from a database to a Replication Server, or from a Replication Server to a database. PowerDesigner models connections as standard data connections (see Data Connections (ILM)) with additional properties (see Replication Server Connection Properties).
Routes – specify one-way message streams that send requests from one Replication Server to another. PowerDesigner models routes as standard process connections (see Process Connections (ILM)) with additional properties (see Replication Server Route Properties).
Logical Connections – consist of a pair of physical connections that are configured in a warm-standby environment (see Creating a Warm Standby Database) to link an active and a standby database. PowerDesigner models logical connections as data connection groups (see Data Connection Groups (ILM)) with additional properties (see Replication Server Logical Connection Properties).
Replication definitions describe the tables, views, databases, and stored procedures that you want to replicate:
Replication definitions – describe a source table to be replicated, the columns you want to copy, and may also describe attributes of the destination table. Destination tables that match the specified characteristics can subscribe to the replication definition. PowerDesigner models Replication Server replication definitions as articles (see Articles (ILM)) with additional properties (see Replication Server Replication Definition and Article Properties).
Database replication definitions – allow you to replicate an entire primary database to one or more replicate databases. PowerDesigner models database replication definitions as publications (see Publications (ILM)) with a Database type and additional properties (see Replication Server Database Replication Definition Properties).
Function replication definitions – specify information about a stored procedure to replicate. PowerDesigner models function replication definitions as publication procedures (see Procedures (ILM)) with additional properties (see Replication Server Function Replication Definition Properties).
Articles – specify a replication definition extension for tables or stored procedures that allow you to assign table or function replication definitions in a publication. PowerDesigner models Replication Server articles as standard articles (see Articles (ILM)) with additional properties (see Replication Server Article Column Properties).
Replication definitions are grouped together into publications that replicate databases can subscribe to:
Publications – collect replication definitions together, to simplify subscriptions. PowerDesigner models Replication Server publications as standard publications (see Publications (ILM)) with additional properties (see Replication Server Publication Properties).
Subscriptions – instruct Replication Server to replicate the data specified in a replication definition or publication to a particular replicate database. PowerDesigner models Replication Server subscriptions as standard subscriptions (see Subscriptions (ILM)) with additional properties (see Replication Server Subscription Properties).
These sub-objects are created inside a Replication Server object:
Users – specifies a user name and password to connect to a Replication Server. PowerDesigner models Replication Server users as standard users (see Users (ILM)) with additional properties (see Replication Server User Properties).
Function strings – contain instructions for executing a function in a database. PowerDesigner models Replication Server function strings as event scripts (see Event Scripts (ILM)) with additional properties (see Replication Server Function String Properties).