www.openlinksw.com
docs.openlinksw.com

Book Home

Contents
Preface

Overview
Installation Guide
Quick Start & Tours
Sample ODBC & JDBC Applications
Conceptual Overview
Server Administration
Virtuoso Cluster Operation
Conductor Administration Interface
Data Access Interfaces
SQL Reference
Virtuoso Cluster Programming
SQL Procedure Language Guide
Database Event Hooks
Data Replication, Synchronization and Transformation Services
Introduction
Snapshot Replication
Transactional Replication
Virtuoso scheduler
Transactional Replication Example
Replication Logger Sample
Web Application Development
XML Support
RDF Database and SPARQL
Web Services
Runtime Hosting
Internet Services
Free Text Search
TPC C Benchmark Kit
Using Virtuoso with Tuxedo
Appendix
Virtuoso Functions Guide

Abstract

This chapter describes how to replicate data between Virtuoso and non-Virtuoso servers.

The material in this chapter covers the programmatic means of performing these operations. You can also use the graphical interface to do replication and synchronization. This is covered in the Replication & Synchronization section of the Visual Server Administration Interface chapter.

Table of Contents

14.1. Introduction
14.1.1. Snapshot replication
14.1.2. Transactional replication
14.2. Snapshot Replication
14.2.1. Non incremental snapshot replication
14.2.2. Incremental snapshot replication
14.2.3. Command reference
14.2.4. Bi-Directional Snapshot Replication
14.2.5. Registry variables
14.2.6. Heterogeneous snapshot replication
14.2.7. Data type mappings
14.2.8. Objects created by incremental snapshot replication
14.2.9. Objects created by bi-directional snapshot replication
14.2.10. Replication system tables
14.2.11. Table snapshot logs
14.3. Transactional Replication
14.3.1. Publishable Items
14.3.2. Errors in Replication
14.3.3. Publisher Transactional Replication Functions
14.3.4. Subscriber Functions
14.3.5. Common Status Functions
14.3.6. Bi-Directional Transactional Replication
14.3.7. Purging replication logs
14.3.8. Objects created by transactional replication
14.4. Virtuoso scheduler
14.4.1. SYS_SCHEDULED_EVENT
14.5. Transactional Replication Example
14.5.1. Transactional Replication Objects Example
14.6. Replication Logger Sample
14.6.1. Configuration of the Sample
14.6.2. Synchronization
14.6.3. Running the Sample
14.6.4. Notes on the Sample's Dynamics