View source | Discuss this page | Page history | Printable version   
Main Page
Upload file
What links here
Recent changes

PDF Books
Add page
Show collection (0 pages)
Collections help


How To Reload the Contents of a Synchronized Table


There are two ways to synchronize data between the main and the store servers:

The most usual approach will be to use the trigger based mechanism. Each time a record is added/modified/deleted from a synchronized table, the change will be captured with a trigger and the change will be promptly synchronized to the store servers that are registered with the main server.

This approach does not cover all the use cases, for instance:

These three cases can be addressed by doing a table reload in the store server. Although it is possible to reload a whole table, sometimes it makes more sense to only reload a subset (for instance, only the records that have been modified in the last week). This case is also covered, because it is possible to provide a SQL where cause to restrict the records that will be resynchronized.

The following sections explains under what circumstances can a synchronize table be reloaded.

Reloading a Remote Table Manually from the Central Server

It is possible to reload from the central server a table that is stored in a store server using the Reload Remote Table process.


The process has three parameters:

The reload tables process is asynchronous. When this parameter window is executed, It will schedule a reload table event in the synchronization engine. It might take some tame to have the data actually updated in the remote server.

Reloading a Remote Table Automatically When the Store Server is Started

It is possible to configure synchronized table so its contents are reloaded each time the store server is restarted.


Only the records that have been inserted/updated after the Last Initial Load time will be reloaded.

Depending on the amount of records that need to be reloaded, the reload process can take some time. During the reload process only the System Administrator role will be available, and the background processes will be disabled.

Retrieved from ""

This page has been accessed 1,766 times. This page was last modified on 3 August 2018, at 11:27. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.