You can append either _allsync or _nosync to a table name to control data restriction for synchronization. You can use these suffixes as an alternative to using publications to control data restrictions. To control data priority, define one or more publications.
If you create a table with a name ending in _allsync, all rows of that table are synchronized at each synchronization—even if they have not changed since the last synchronization.
You can store user specific or client specific data in allsync tables. You can then upload the data in the UltraLite table to a temporary table in the consolidated database on synchronization. Synchronization scripts can control the data and save you from having to maintain that data in the consolidated database.
If you create a table with a name ending in _nosync, all rows of that table are excluded from synchronization. You can use these tables for persistent data that is not required in the consolidated database's table.
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|