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

SQL Anywhere 10.0.1 » UltraLite - Database Management and Reference » Exploring the CustDB Samples for UltraLite » Lesson 4: Synchronizing with the CustDB consolidated database

Lesson 4: Synchronizing with the CustDB consolidated database Next Page

Confirming the synchronization at the consolidated database


You 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. Choose Start > Programs > SQL Anywhere 10 > SQL Anywhere > Interactive SQL.

      The Interactive SQL Connect dialog appears.

    2. Select ODBC Data Source Name and choose SQL Anywhere 10 CustDB from the dropdown list.

  2. Confirm the status change of the approved and denied orders.

    To confirm that the approval and denial have been synchronized, issue 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. Confirm that the deleted order has been removed.

    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. Launch Sybase Central.

    Choose Programs > Sybase > SQL Anywhere 10 > Sybase Central.

  2. Connect to the consolidated CustDB database.

    1. Choose Connections > Connect with SQL Anywhere 10.

      The Connect dialog appears.

    2. Select ODBC Data Source Name and choose SQL Anywhere 10 CustDB from the dropdown list.

  3. Browse to the ULOrder table and confirm your modifications:

    1. Double-click Tables to display all tables.

    2. Double-click the ULOrder table.

    3. Click the Data tab and check that:

      • Check that order 5100 is approved, and 5101 is denied.

      • Check that order 5102 has been deleted.