Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 (Français) » MobiLink - Getting Started » MobiLink Tutorials » Tutorial: Synchronizing with Microsoft Excel

 

Lesson 7: Synchronize

The dbmlsync utility initiates MobiLink synchronization for SQL Anywhere remote databases. Before starting dbmlsync, add order data and comments to your remote database.

♦  To set up your remote data (client-side)
  1. Connect to the MobiLink client database in Interactive SQL:

    Run the following command:

    dbisql -c "eng=remote1;uid=DBA;pwd=sql"
  2. Add an order to the RemoteOrders table in the client database.

    Execute the following command in Interactive SQL.

    INSERT INTO RemoteOrders (order_id, product_id, quantity, order_status)
     VALUES (1,12312,10,'new')
  3. Add a comment to the OrderComments table in the client database.

    Execute the following command in Interactive SQL.

    INSERT INTO OrderComments (comment_id, order_id, order_comment)
     VALUES (1,1,'send promotional material with the order')
  4. Commit your changes.

    Execute the following in Interactive SQL:

    COMMIT;
♦  To start the synchronization client (client-side)

Once you have started the MobiLink synchronization client, an output screen appears indicating that the synchronization succeeded. SQL-based synchronization transferred rows in the client RemoteOrders table to the RemoteOrders table in the consolidated database.

Java processing inserted your comment in the order_central.xls worksheet. The information stored in the order_central.xls worksheet is downloaded to the client

In Interactive SQL, select from the OrderComments table to verify that the row was downloaded.

Note

Rows downloaded using direct row handling are not printed by the mlsrv11 -v+ option, but are printed in the remote log by the remote -v+ option.

Further reading

For more information about dbmlsync, see SQL Anywhere clients.