You should now have a working synchronization system set up. In this lesson, you test it by inserting some data and synchronizing.
Prérequis
This lesson assumes you have the roles and privileges listed in the Privileges section at the start of this tutorial: Tutorial: Changing a schema using the script version clause.
This lesson assumes you have completed all preceding lessons. See Lesson 1: Creating and configuring the consolidated database.
Using the instance of Interactive SQL that is connected to the consolidated database, execute the following SQL statement to insert a row in the customer table.
INSERT INTO customer VALUES( 100, 'John Jones', '519-555-1234' ); COMMIT; |
Using the instance of Interactive SQL that is connected to the remote database, execute the following SQL statement to insert a row in the customer table.
INSERT INTO customer VALUES( 1, 'Willie Lowman', '705-411-6372' ); COMMIT; |
Synchronize by running the following command.
dbmlsync -v+ -ot sync1.txt -c UID=DBA;PWD=sql;SERVER=remote -s my_sub -k |
![]() |
Discuter à propos de cette page dans DocCommentXchange.
|
Copyright © 2013, SAP AG ou société affiliée SAP - SAP Sybase SQL Anywhere 16.0 |