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

SQL Anywhere 11.0.0 » UltraLite - Database Management and Reference » Using UltraLite Databases » Exploring the CustDB samples for UltraLite » Lesson 4: Synchronizing with the CustDB consolidated database

 

Confirming the synchronization at the consolidated database

You can use Interactive SQL or Sybase Central to connect to the consolidated database and confirm that your changes were synchronized.

To confirm the synchronization (Interactive SQL)

  1. Connect to the consolidated database from Interactive SQL.

    1. From the Start menu, choose Programs » SQL Anywhere 11 » Interactive SQL.
    2. Click ODBC Data Source Name and choose SQL Anywhere 11 CustDB.
  2. To confirm that the approval and denial have been synchronized, execute the following statement:

    SELECT order_id, status
    FROM ULOrder
    WHERE status IS NOT NULL;

    The results show that order 5100 is approved, and 5101 is denied.

  3. The deleted order has an order_id of 5102. The following query returns no rows, demonstrating that the order has been removed from the system.

    SELECT *
    FROM ULOrder
    WHERE order_id = 5102;

To confirm the synchronization (Sybase Central)

  1. From the Start menu, choose Programs » SQL Anywhere 11 » Sybase Central.

  2. From the Connections menu, choose Connect With SQL Anywhere 11.

  3. Click ODBC Data Source Name.

  4. Click Browse and choose SQL Anywhere 11 CustDB.

  5. Click OK.

  6. Click OK.

  7. Double-click Tables.

  8. Double-click ULOrder (DBA).

  9. Click the Data tab and verify that order 5100 is approved, order 5101 is denied, and order 5102 is deleted.