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.

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:

SELECT * FROM news
go
Tutorial complete

You have now completed the tutorial.