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

SQL Anywhere 12.0.0 » UltraLite - Database Management and Reference » UltraLite as a MobiLink client » UltraLite clients

 

Designing synchronization in UltraLite

All data in an UltraLite database is synchronized by default. If you are new to deploying UltraLite as a MobiLink remote database, plan to use the default behavior initially.

Once you become comfortable with the synchronization process, you may decide to customize the behavior of the synchronization operation to capture more complex business logic. Designing custom synchronization behavior requires that you ask yourself the following questions. If your business requirements are simple, you may only need to use a single synchronization feature. However, in very complex deployments, you may need to use multiple synchronization features to configure the synchronization behavior you require.

Design question If you answer yes, use the following
Do you want to exclude tables from synchronization? The nosync table name suffix allows you to identify any tables that you do not want to synchronize. See Non-synchronizing tables in UltraLite.
Do you only want to synchronize entire tables even when data hasn't changed? The allsync table name suffix allows you to synchronize the entire table, even when no changes are detected. See Allsync tables in UltraLite.
Do you want to synchronize an entire table or just rows that meet specific conditions? Does some of the data require synchronization priority due to its importance or time-sensitivity?

A publication includes articles that list the tables that require synchronization. An article can include a WHERE clause that specifies the rows to upload based on whether the rows meet the defined criteria.

Multiple publications can address priority issues that require certain UltraLite data be uploaded before others. See Publications in UltraLite.

Do you require a table order for synchronization because you have cycles of foreign keys? The Table Order synchronization parameter allows you to determine the order of synchronization operations when you have foreign key cycles. However, foreign key cycles are generally not recommended for UltraLite. See Table order in UltraLite.
Do you want to control synchronization behavior? For example, do you need downloads to occur at the same time as uploads? Or do you want to change bi-directional synchronization to one-way only?

Use the appropriate synchronization parameter as part of:

  • Your application's synchronization structure (or the synchronization enumeration).

  • The ulsync utility's -e option.

See UltraLite synchronization parameters and network protocol options.

Do you want your UltraLite client to be TLS-enabled? What encryption algorithm you choose determines how your device must be set up according to the platform that runs on that device. See Deploy UltraLite with TLS-enabled synchronization.
 See also

Non-synchronizing tables in UltraLite
Allsync tables in UltraLite
Publications in UltraLite
Table order in UltraLite
Adding synchronization to your UltraLite application