www.openlinksw.com
docs.openlinksw.com

Book Home

Contents
Preface

Overview
Installation Guide
Quick Start & Tours
Sample ODBC & JDBC Applications
Conceptual Overview
Administration
Data Access Interfaces
SQL Reference
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 Data Access and Data Management
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

11.1. Introduction
11.1.1. Snapshot replication
11.1.2. Transactional replication
11.2. Snapshot Replication
11.2.1. Non incremental snapshot replication
11.2.2. Incremental snapshot replication
11.2.3. Command reference
11.2.4. Bi-Directional Snapshot Replication
11.2.5. Registry variables
11.2.6. Heterogeneous snapshot replication
11.2.7. Data type mappings
11.2.8. Objects created by incremental snapshot replication
11.2.9. Objects created by bi-directional snapshot replication
11.2.10. Replication system tables
11.2.11. Table snapshot logs
11.3. Transactional Replication
11.3.1. Publishable Items
11.3.2. Errors in Replication
11.3.3. Publisher Transactional Replication Functions
11.3.4. Subscriber Functions
11.3.5. Common Status Functions
11.3.6. Bi-Directional Transactional Replication
11.3.7. Purging replication logs
11.3.8. Objects created by transactional replication
11.4. Virtuoso scheduler
11.4.1. SYS_SCHEDULED_EVENT
11.5. Transactional Replication Example
11.5.1. Transactional Replication Objects Example
11.6. Replication Logger Sample
11.6.1. Configuration of the Sample
11.6.2. Synchronization
11.6.3. Running the Sample
11.6.4. Notes on the Sample's Dynamics