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 of the products.
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 of the rows and columns of the ULProduct table at each synchronization:
SELECT prod_id, price, prod_name FROM ULProduct