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

SQL Anywhere 12.0.1 » MobiLink - Client Administration » SQL Anywhere clients for MobiLink » Scripted upload » Tutorial: Using scripted upload

 

Lesson 8: Demonstrating the scripted upload

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

 Demonstrate the scripted upload
  1. Using the instance of Interactive SQL connected to the remote database, insert data to synchronize using scripted upload. Run the following SQL statements on the remote database:

    INSERT INTO employee(id, name, salary) VALUES( 7, 'black', 700 );
    INSERT INTO employee(id, name, salary) VALUES( 8, 'anderson', 800 );
    INSERT INTO employee(id, name, salary) VALUES( 9, 'dilon', 900 );
    INSERT INTO employee(id, name, salary) VALUES( 10, 'dwit', 1000 );
    INSERT INTO employee(id, name, salary) VALUES( 11, 'dwit', 1100 );
    COMMIT;
  2. At a command prompt, start the MobiLink server:

    mlsrv12 -c "DSN=dsn_consol" -o mlserver.mls -v+ -dl -zu+
  3. Start a synchronization using dbmlsync:

    dbmlsync -c "DSN=dsn_remote" -k -uo -o remote.mlc -v+
  4. Run the following SQL statement to verify that the inserts were uploaded.

    select * from employee

    You should see the values that were inserted at the beginning of this lesson.

  5. Proceed to Cleaning up.