Connect to your consolidated database in Interactive SQL if you are not already connected.

Run the following command:

dbisql -c "dsn=sis_cons"

Execute the following SQL statements:

INSERT INTO PushRequest(mluser, subject, content)
    VALUES ('sis_user1', 'sync', 'not used');
COMMIT;

Wait a few seconds for the synchronization to occur.

When populated, the PushRequest table supplies rows to the Notifier's request_cursor script. The request_cursor script determines what information is sent in the message, and which remote devices receive the information.

Execute the following SQL statements to make a change in the Dealer table on the consolidated database, prompting server-initiated synchronization:

UPDATE Dealer
    SET RATING = 'B' WHERE name = 'Geo'; 
COMMIT;

Wait a few seconds for the synchronization to occur.

In this case, the Notifier begin_poll script detects changes in the dealer table and populates the PushRequest table appropriately. As before, once the PushRequest table is populated, the Notifier request_cursor script determines what information is sent in the message, and which remote devices receive the information.

Confirm that the Dealer table on the remote database was updated.

Execute the following SQL statement:

SELECT * FROM Dealer

The rating for Geo should now be B.