SYNCHRONIZATION OF SERVER DATABASE WITH CLIENT DATABASE USING DISTRIBUTION TABLES

A storage medium encoded is provided for use in synchronization of a server database, which includes a plurality of tables and which is accessible on a server computer system, and a client database, which is accessible on a client computer system and which includes a subset of the tables in the server database, the storage medium comprising a first distribution point table in the server database which has the property that modification of such first distribution point table may influence distribution of information from the server database to the client database during a synchronization of the server database and the client database; a first distribution table which corresponds to the first distribution point table which is separate from the server database application tables and which includes identification information that identifies occurrences of information within the server database that may require distribution to the client database during a synchronization of the server database and the client database; and a first extract program which references the identification information in the first distribution table and corresponding information in the first distribution point table to identify information in the first distribution point table to be distributed to the client database during a synchronization of the server database and the client database.