Modeling a Warm Standby Application

A warm standby application is a pair of Adaptive Server or SQL Server databases, one of which is a backup of the other. Client applications update the active database, and Replication Server maintains the standby database as a copy of the active database.

1. Create a database in your DMM and link it to a PDM that contains the structure of the active database.
2. Create a Replication Server replication process, and link the database to it with a connection.
3. Right-click the database and select Create Standby Database.
   PowerDesigner converts the standard connection into a logical connection (see Data Connection Groups (DMM)) between the active database, the replication process, and a standby database, that it creates and links to the PDM used to describe the active database.