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

12.1. Introduction
12.1.1. Snapshot replication
12.1.2. Transactional replication
12.2. Snapshot Replication
12.2.1. Non incremental snapshot replication
12.2.2. Incremental snapshot replication
12.2.3. Command reference
12.2.4. Bi-Directional Snapshot Replication
12.2.5. Registry variables
12.2.6. Heterogeneous snapshot replication
12.2.7. Data type mappings
12.2.8. Objects created by incremental snapshot replication
12.2.9. Objects created by bi-directional snapshot replication
12.2.10. Replication system tables
12.2.11. Table snapshot logs
12.3. Transactional Replication
12.3.1. Publishable Items
12.3.2. Errors in Replication
12.3.3. Publisher Transactional Replication Functions
12.3.4. Subscriber Functions
12.3.5. Common Status Functions
12.3.6. Bi-Directional Transactional Replication
12.3.7. Purging replication logs
12.3.8. Objects created by transactional replication
12.4. Virtuoso scheduler
12.4.1. SYS_SCHEDULED_EVENT
12.5. Transactional Replication Example
12.5.1. Transactional Replication Objects Example
12.6. Replication Logger Sample
12.6.1. Configuration of the Sample
12.6.2. Synchronization
12.6.3. Running the Sample
12.6.4. Notes on the Sample's Dynamics