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
You have now completed the tutorial.
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|