Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Remote » Deploying and Synchronizing Databases with SQL Remote

Changes to avoid on a running system Next Page

Synchronizing databases

What is synchronization?

SQL Remote replication is carried out using the information in the transaction log, but there are two circumstances where SQL Remote deletes all existing rows from those tables of a remote database that form part of a publication, and copies the publication's entire contents from the consolidated database to the remote site. This process is called synchronization.

When to synchronize

Synchronization is used under the following circumstances:

How to synchronize

Synchronizing a remote database can be done in the following ways:

Mixed operating systems and database extraction
Notes on synchronization and extraction