Lesson 11: Viewing the data in the remote database

This lesson assumes you have completed all preceding lessons. See Lesson 1: Designing the schemas.

After successfully synchronizing the remote client to the consolidated database through the MobiLink server, the remote data should be populated with information relevant to one salesperson. You can verify that the database is populated in Sybase Central using the SQL Anywhere 12 plug-in.

 View the data in the remote database

  1. Start Sybase Central.

  2. Connect to the remote database:

    1. In the left pane, right-click SQL Anywhere 12, and click Connect.

    2. In the Authentication dropdown list, click Database, and type DBA as the User ID and sql as the Password.

    3. In the Action dropdown list, click Connect To A Running Database On This Computer, and type remote_eng as the Server Name and remote_db as the Database Name.

    4. Click Connect.

  3. Click the ORDERS table, and click the Data tab in the right pane.

    In the ORDERS tables, all the records are for the salesperson with an identifier of 154. This particular salesperson is not concerned with the sales information of other salespeople. For this reason, you set the synchronization scripts to filter out rows by the remote ID, and you set this database's remote ID to the value of a particular salesperson identifier. Now this particular salesperson's database takes up less space, and requires less time to synchronize. Since the remote database size is kept to a minimum, frequently performed operations, such as entering a new sale or processing a refund on a previous sale, runs faster and more efficiently.

  4. Proceed to Cleaning up.

Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1