Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » UltraLite - Database Management and Reference » Using UltraLite Databases » Working with UltraLite databases » Working with UltraLite tables and columns

 

Using allsync and nosync suffixes

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.

    Tip

    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.

See also
Example

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.