The replication wizard provides a quick way to configure a Replication Server process for replicating one database to another. You can replicate the entire database or choose specific tables to replicate. You can run the wizard as many times as necessary to create additional replications on a single or multiple Replication Servers.
PrerequisitesÂ
Although you can launch the Replication wizard without already having modeled your databases in PDMs, we recommend that you as a minimum create a PDM to represent the structure of your primary database. You can reverse-engineer an existing database by selecting .
-
Select to open the New Model window and select Information Liquidity Model in the Model Type list and Information Liquidity Diagram in the Diagram pane. Click the Extensions button to open the Extended Model Definitions dialog, click the General Purpose sub-tab, select the appropriate version of Replication Server, and then click OK to return to the New Model window.
-
Click OK to create the ILM, which opens with an empty diagram.
-
Click the Replication Server tool in the palette, and then click in the center of the diagram to create a replication process. Right-click the Replication server symbol, and select Replication Wizard to open a wizard that guides you through configuring Replication Server for replicating data between your source and target databases.
When you click OK to close the wizard, PowerDesigner will create source and target database objects in your ILM, as well as all the necessary articles, publications, and subscriptions that Replication Server requires to manage the replication of data between them.