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

SQL Anywhere 11.0.1 » SQL Anywhere Server - Database Administration » Replication » Replicating data with Replication Server


Tutorial: Replicate data using Replication Server

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.

Lesson 1: Create the SQL Anywhere databases
Lesson 2: Start the database servers
Lesson 3: Set up the Open Servers in your system
Lesson 4: Confirm that the Open Servers are configured properly
Lesson 5: Add Replication Server information to the primary database
Lesson 6: Create the table for the primary database
Lesson 7: Add Replication Server information to the replicate database
Lesson 8: Create the tables for the replicate database
Lesson 9: Set up Replication Server
Lesson 10: Enter data at the primary site for replication