By creating the table using SYNCHRONIZE DOWNLOAD, you exclude entire tables from the upload operation. You can use these tables for data that should not synchronized to the consolidated database. Other than being excluded from synchronization, you can use these tables in exactly the same way as other tables in the UltraLite database.
You can alternatively use publications to achieve the same effect.
The synchronization type for a table can only be changed if it does not have any unsynchronized changes that need to be uploaded.
As an alternative to creating or altering a table with the SYNCHRONIZE DOWNLOAD clause, you can append the phrase _download_only to the table name to turn it into a download-only table.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|