This section provides a step-by-step tutorial describing how to replicate data from a primary database to a replicate database. Both databases in the tutorial are SQL Anywhere databases.

Replication Server assumed

This tutorial assumes you have a running Replication Server on Windows, and that it, the Replication Agent, and SQL Anywhere are all running on the same computer.

For more information about how to install or configure Replication Server, see the Replication Server documentation.

What is in the tutorial

This tutorial describes how to replicate only tables.

For information about replicating procedures, see Preparing procedures and functions for replication.

The tutorial uses a simple example of a (very) primitive office news system: a single table with an ID column holding an integer, a column holding the user ID of the author of the news item, and a column holding the text of the news item. The id column and the author column make up the primary key.

Before you work through the tutorial, create a directory (for example, c:\tutorial) to hold the files you create in the tutorial. The SQL Anywhere log scanning tools assume that all transaction logs located in a directory belong to the same database, so in this tutorial, you create a directory for each database (c:\tutorial\primedb and c:\tutorial\repdb) because the LTM scans offline transaction logs.