STOP SYNCHRONIZATION DELETE

Ordinarily, SQL Anywhere and UltraLite remote databases automatically log any changes made to tables or columns that are being synchronized, and then upload these changes to the consolidated database during the next synchronization. This statement allows you to temporarily suspend logging of delete operations to a SQL Anywhere or UltraLite remote database.

None of the delete operations executed on a connection between the time the connection executes STOP SYNCHRONIZATION DELETE and the time the connection executes START SYNCHRONIZATION DELETE are synchronized.

A single START SYNCHRONIZATION DELETE statement restarts the logging, regardless of the number of STOP SYNCHRONIZATION DELETE statements preceding it.

This statement can be useful to make corrections to a remote database, but should be used with caution as it effectively disables MobiLink synchronization.

Do not use STOP SYNCHRONIZATION DELETE if your application does not synchronize data.

DBA authority

None.

• ULConnection.StartSynchronizationDelete method [UltraLite.NET]
• ULConnection.StopSynchronizationDelete method [UltraLite.NET]
• START SYNCHRONIZATION DELETE statement [MobiLink]

For an example, see START SYNCHRONIZATION DELETE statement [MobiLink].