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:

mlsrv12 -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 to verify that the inserts were uploaded.

select * from employee

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

Proceed to Cleaning up.