Back Home

SymmetricDS triggers are installed, changes are captured for any Data Manipulation Language (DML) statements performed by external applications. Note that no additional libraries or changes are needed by the applications that use the database and SymmetricDS does not have to be online for data to be captured.

Why Database Triggers?

There are several industry recognized techniques to capture changing data for replication, synchronization and integration in a relational database.

  • Lazy data capture queries changed data from a source system using some SQL condition (like a time stamp column).
  • Trigger-based data capture installs database triggers to capture changes.
  • Log-based data capture reads data changes from proprietary database recovery logs.

Setup for Example

setup server 

../bin/dbimport --engine corp-000 --format XML create_sample.xml
../bin/symadmin --engine corp-000 create-sym-tables
../bin/dbimport --engine corp-000 insert_sample.sql

setup store  - create sample data 
../bin/dbimport --engine store-001 --format XML create_sample.xml
../bin/symadmin --engine store-001 create-sym-tables

and register 
../bin/symadmin --engine corp-000 open-registration STORE 001

../bin/sym --engine corp-000 --port 8091

../bin/sym --engine store-001 --port 9090

initial load 
../bin/symadmin --engine store-001 reload-node 000
../bin/symadmin --engine corp-000 reload-node 001

Multi - Database Support

  • MySQL version 5.0.2 and above
  • MariaDB version 5.1 and above
  • Oracle version 10g and above
  • PostgreSQL version 8.2.5 and above
  • Sql Server 2005 and above
  • Sql Server Azure
  • HSQLDB 2.x
  • H2 1.x
  • Apache Derby and above
  • IBM DB2 9.5
  • Firebird 2.0 and above
  • Interbase 2009 and above
  • Greenplum 8.2.15 and above
  • SQLite 3 and above
  • Sybase Adaptive Server Enterprise 12.5 and above
  • Sybase SQL Anywhere 9 and above
symmetricds.txt · Last modified: 2013/09/16 06:36 by root
RSS - 200 © CrosswireDigitialMedia Ltd