Lesson 7: Inserting data in the remote database

This lesson assumes you have completed all preceding lessons. See Lesson 1: Creating and configuring the consolidated database.

In this lesson, you insert some more data into the remote and consolidated databases using the new schema.

 Insert data in the remote database

  1. Using Interactive SQL, execute the following SQL statements on the remote database.

    INSERT INTO customer VALUES( 3, 'Mo Hamid', '613-411-9999', '613-502-1212' );
COMMIT;

  2. Using Interactive SQL, execute the following SQL statements on the consolidated database.

    INSERT INTO customer VALUES( 101, 'Theo Tug', '212-911-7677', '212-311-3900' );
COMMIT;

  3. Proceed to Lesson 8: Synchronizing.

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