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 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



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

store 
../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

• Sample Test Data

• 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 10.3.2.1 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