Setting Up Bidirectional Replication

Learn how to set up a two-way replication of data definition language (DDL) transactions between two Adaptive Server databases.

1. Create a bidirectional MSA replication environment.
   For steps, see Chapter 12, “Managing Replicated Objects Using MultiSite Availability,” in the Replication Server Administration Guide Volume 1.
2. Grant “set session authorization” privilege to a maintenance user on the destination database, as shown in the following example:

   grant set session authorization to maint_user

3. In the destination database, set dsi_replication_ddl to on to enable bidirectional DDL replication, as shown in the following example:

   alter connection to dataserver.database set dsi_replication_ddl on

4. Replicate DDL transactions.