AllowDownloadDupRows

Prevents errors from being raised when a synchronization encounters downloaded rows with duplicate primary keys.

Set this property to 0 to raise errors and roll back the download; otherwise, set to 1 to raise warnings and continue the download.

This property is only available in UltraLite C/C++.

CheckpointStore

Adds additional checkpoints of the database during synchronization to limit database growth during the synchronization process.

Set this property to 1 to enable this feature, which is beneficial for large downloads with many updates but slows down synchronization; otherwise, set to 0, which is the default.

DisableConcurrency

Disallows database access from other threads during synchronization during the upload phase.

Set this property to 0 to allow concurrent database access; otherwise, set to 1. By default, this property is set to 0.

TableOrder

Sets the table order required for priority synchronization if the UltraLite default table ordering is not suitable for your deployment.

Set this property to a list of table names, arranged in the desired order for upload. For UltraLite, use a comma delimited list; for ulsync, use a semicolon delimited list. By default, the order is based on foreign key relationships. Typically, the default is acceptable when the foreign keys on your consolidated database match the UltraLite remote and there are no foreign key cycles.

Quote tables names with either single or double quotes. For example, "Customer,Sales" and 'Customer,Sales' are both supported in UltraLite.

If you include tables that are not included in the synchronization, they are ignored. Any tables that you do not list are appropriately sorted based on the foreign keys defined in the remote database.

The order of tables on the download is the same as those you define for upload.

You only need to explicitly set the table order if your UltraLite tables: