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


Lesson 10: Enter data at the primary site for replication

You can now replicate data from the primary database to the replicate database. As an example, connect to the primary database using the isql utility, and enter a row in the news table.

INSERT news (id, text)
VALUES (1, 'Test news item.' )

The SQL Anywhere LTM sends only committed changes to the Replication Server. The data change is replicated next time the LTM polls the transaction log.

Check that the data has been sent to repdb by connecting to the replicate database using the isql utility and executing the following SQL statement:

Tutorial complete

You have now completed the tutorial.