Collection Contents Index Create a subscription for your replication Next PDF

SQL Anywhere® Server - Database Administration  > 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.' )
COMMIT
go

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.

Tutorial complete

You have now completed the tutorial.


Collection Contents Index Create a subscription for your replication Next PDF