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.
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.
In the CustDB.udb sample database, you can see that one table was declared a nosync table because the table name is named ULIdentifyEmployee_nosync. Therefore, no matter how data changes in this table, it is never synchronized with MobiLink and information will not appear in the CustDB.db consolidated database.
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|