Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
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.
Product information can be inserted, deleted, or updated at the consolidated database. The script corresponding to these operations
is as follows:
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