Synchronizing products in the CustDB sample

Business rules

All rows are downloaded for ULProduct—this is called snapshot synchronization.

See Snapshot synchronization.

The business rules for the ULProduct table are as follows:

  • Products can only be modified at the consolidated database.

  • Each remote database contains all the products.

Downloads

Product information can be inserted, deleted, or updated at the consolidated database. The script corresponding to these operations is as follows:

  • download_cursor   The following download_cursor script downloads all the rows and columns of the ULProduct table at each synchronization:
    SELECT prod_id, price, prod_name FROM ULProduct