Table of Contents Previous Next


7 Common Operations : 7.7 Switching the Controller Database

Note: If the controller database is an Oracle or a SQL Server publication database, then a second Oracle or SQL Server publication database cannot be added to create a second single-master replication system. In order for xDB Replication Server to run more than one single-master replication systems consisting of Oracle or SQL Server publication databases, a Postgres publication database must be designated as the controller database.
Upon switching the controller database, the publication server updates the xDB Replication Configuration file so the parameters user, password, host, port, database, and type are set to the connection and authentication settings for the selected publication database.
Step 1: Make sure the publication server whose node is the parent of the publication databases is running and has been registered in the xDB Replication Console you are using. See Section 5.2.1 for directions on starting and registering a publication server.
Step 2: Select the Publication Database node corresponding to the publication database that you wish to set as the controller database.
Step 3: Click the secondary mouse button on the Publication Database node and choose Set as Controller database.
Step 4: In the Set as Controller database confirmation box, click the Yes button.
Step 5: The selected publication database has now been set as the controller database.
Step 6: The value Yes in the Controller database field of the Property window indicates this database is the controller database.

7 Common Operations : 7.7 Switching the Controller Database

Table of Contents Previous Next