By creating or altering a table using SYNCHRONIZE ALL you control whether to change the synchronization behavior during upload so that it synchronizes all table data, even if nothing has changed since the previous synchronization session.
The synchronization type for a table can only be changed if it does not have any unsynchronized changes that need to be uploaded.
Some UltraLite applications require user/client-specific data that you can store in a SYNCHRONIZE ALL TABLES. You can upload the data in the table to a temporary table in the consolidated database, use the data to control synchronization by your other scripts without having the data maintained in the consolidated database. For example, you may want your UltraLite applications to indicate which channels or topics they are interested in, and use this information to download the appropriate rows.
As an alternative to creating or altering a table with the SYNCHRONIZE ALL clause, you can append the phrase _allsync to the table name to turn it into a synchronize-all table.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|