Chapter 6. Using the Graphical User Interfaces
6.1. Publisher
6.1.1. Creating a new Publication
To create a new publication,
Click on the Publisher menu and select "Create Publication" (or press CTRL-P)
A "Create Publication dialog appears. Fill in the following fields:
Publication Name: Enter a name for the publication you are creating.
Conflict Resolver: Select either "Publisher_wins" or "Subscriber_wins." This will determine which database's record will be the final one in the event of a direct conflict.
Then click on "Next."
Next, the "Select Tables for Publication" dialog appears. The existing database tables are shown on the left pane, and the selected tables are moved from there to the right pane.
For tables with relations, select the "root" or "parent" table first, and then its child. dbreplicator does check that all related tables are included in the publication, but it is up to the user to get the order correct. This may be improved in a future release.
Then click on "Next."
After selecting the tables to include in the publication, the Set filter clause dialog appears.
This allows filtering in selected tables by setting conditions (e.g. state != 'NJ').
After setting the desired filters, click 'Finish'. This should then present you with the 'Published Successfully' dialog.
The publication is now ready for subscription.
The publication can now be viewed in the publisher main publications window.
Here, you can also perform administrative operations on the publication such as adding or dropping tables, or dropping the publication altogether.
