Lesson 8: Demonstrating the scripted upload

In this lesson, you run SQL statement and commands to demonstrate a scripted upload.

Prérequis

This lesson assumes you have the roles and privileges listed in the Privileges section at the start of this tutorial: Tutorial: Using scripted upload.

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

Task

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;

At a command prompt, start the MobiLink server:

mlsrv16 -c "DSN=dsn_consol" -o mlserver.mls -v+ -dl -zu+

Start a synchronization using dbmlsync:

dbmlsync -c "DSN=dsn_remote" -k -uo -o remote.mlc -v+

Run the following SQL statement using the instance of Interactive SQL connected to the remote database to verify that the inserts were uploaded.
select * from employee

Résultat

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

Suivant

Proceed to Cleaning up.

Discuter à propos de cette page dans DocCommentXchange.