• Info
• Initial State
• View Source
• Run

Replication Demo between two Datsources (DSNs)

RE-DS-1 Replication Demo between two Datsources (DSNs)

Replication Demo between two Datsources (DSNs)

Preliminaries

This sample shows how to replicate two heterogeneous DSNs (MySQL DSN and Microsoft SQL Server DSN for example) with all logic in Virtuoso. The replicated table has two columns. First is varchar Primary key, second integer representing user data.

Sample includes:

• Select DSN for demo. There must be two connected DSNs to start the sample.
• Create tables on the two DSNs.
• Attach tables from these DSNs.
• Show simple page with table content.

How it works:

• The Primary key plus timestamp column from source is replicated locally.
• On initial state all date from the first DSN s copyed to the Second.
• The user table on the first DSN has one timestamp column more that the table on the second. This column is used to get new / changed rows on replication state.

Instructions for setting:

1. Click on the "Set Initial State" to create virtuoso table.
2. Click on the "Run" links to actually experience the demo.

Important: This sample is not thread save.