Conductor "Replication" offers manage Virtuoso Replication. You are offered with "Basic", "Incremental", "Bidirectional Snapshot" and "Transactional" sub-tabs-
From Replication/Basic/Query(Table select)to local to replicate local table(s) to another data source click Create New Snapshot and follow the wizard.
To copy the changes from the local table to the remote select some replications and press Synchronize
To drop the replication definition without dropping the destination table select some replications and press Remove
To drop the replication definition and the destination table select some replications and press Remove & Drop Remote
To copy the changes from the local table to the remote automatically select some replications, enter minutes in Scheduled Interval and press Schedule
To remove scheduled update select the replications enter 0 in "Scheduled Interval" and press Schedule
|
| Figure: 7.8.1.1. Snapshot Replication |
|
| Figure: 7.8.1.2. Snapshot Replication |
|
| Figure: 7.8.1.3. Snapshot Replication |
|
| Figure: 7.8.1.4. Snapshot Replication |
|
| Figure: 7.8.1.5. Snapshot Replication |
|
| Figure: 7.8.1.6. Snapshot Replication |
|
| Figure: 7.8.1.7. Snapshot Replication |
The Transaction Publication screen lists publications. You can add, edit or remove publications as necessary, each time using the guide-lines of the wizard.
|
| Figure: 7.8.2.1.1. Transaction Replication - Publications |
When creating a new publication you must supply a name. At this point you have the option to create an updateable publication - see the Bi-Directional Transactional Replication section for more details - which allows updates to come from subscribers rather than being limited to originating from the publisher only.
|
| Figure: 7.8.2.1.2. Transaction Replication - New Publication |
|
| Figure: 7.8.2.1.3. Transaction Replication - List of Publications |
Once a new publication has been made you can add database objects to it using the Add ... buttons, or remove them by selecting their checkbox and using the Remove button. To add a new table to the publication click on Add Table/Procedure. Follow the wizard by choosing the appropriate database/catalog by clicking on its name, you will then be presented with the tables within it.
|
| Figure: 7.8.2.1.4. Transaction Replication - Publish Tables and Procedures |
Select the tables to publish using the checkboxes and press Add to Publication to add the tables and continue.
Once returned the publication screen, the published tables will be listed. Updatable publication will need conflict resolvers in case of conflicting data arriving from a subscriber. Click on the table name to manage the resolvers list.
|
| Figure: 7.8.2.1.5. Transaction Replication - Published Items |
Use the Add/Remove to add or remove selected resolvers.
Click on New Resolver to add a new resolver. You have the following details to contend with:
Conflict resolver name suffix.
Resolver order number.
The resolver type, one of: Insert, Update, or Delete for resolving such SQL queries.
The kind of resolver. Class can be one of the following:
This should specify the column name if class is not one of 'pub_wins', 'sub_wins' or 'custom'.
|
| Figure: 7.8.2.1.6. Transaction Replication - Resolvers |
|
| Figure: 7.8.2.1.7. Transaction Replication - Advanced |
To add new subscription click at New Subscription and follow the wizard.
Click Edit to change properties.
To drop subscription click at link Drop.
To synchronize subscription click the Sync button.
To disconnect all subscriptions click at Disconnect all button.
To load image file click at Load image button and follow the wizard
|
| Figure: 7.8.2.2.1. Transaction Replication - Subscription |
|
| Figure: 7.8.2.2.2. Transaction Replication - Subscription |
|
Previous
Query Tools |
Chapter Contents |
Next
Database Administration |
