• Info
• Initial State
• View Source
• Run

Bidirectional Transactional Replication Setup

RE-XB-2 Creating a publication

Adding tables to publication

To add a table to publication execute the following steps:

1. Login to the Conductor UI using the dba account.
2. Go to the "Replication" tab, then go to the "Transactional" tab and then go the "Publications" sub-tab.
3. From the publications list select the link with the name of your publication ("repldemo").
4. Press the "Add Tables" button.
5. Select a database, then a table or multiple tables (select "Demo.demo.Orders"), and then press "Add to Publication" button.

Equivalent SQL commands to above

1. Connect to the Virtuoso server via ISQL utility as DBA user.
2. Add table "Demo.demo.Orders" to publication "repldemo"

   SQL> repl_pub_add('repldemo', 'Demo.demo.Orders', 2, 1, 0);