|
  
|
||
|
|
||
Once set up for synchronisation the sync can be activated.
Please check the following first:
Select the Synchronize button
If continuous synchronization is selected, once started the application will synchronize until stopped by pressing the Red traffic light button:-
Once synchronization is started the data selection form goes into active state. Active table synchronization is indicated by the 'Status' indicator. This is
Green for off/inactive
Red for Active
The status is also shown by the Start Date/Time, the Record Count and finally the End Date/Time
An active thread will not have an end date.
When large tables are activated there is a delay between the Status indicator changing from Green to Red and the record count appearing. This is because each time the cycle starts the table is queried and the relevant fields converted, this is to ensure that all changes are pulled from the server.
Thus when the record count shows the data has started to be written to SQL server.When synchronisation starts there is often a delay in an record count showing and ExSync appears to be doing nothing in the process list. This because all the processing is being done on the Pervasive SQL server.
If you look at the task manager process list on the PSQL server for ntdbsmgr.exe you will see the memory increasing as it executes the queries. At his point there is no real load on ExSync, it copes with calculating the data easily. Once the record counts start to appear the data is being pushed into the SQL database and the memory usage of ExSync will start to increase.
Below is a view of an active synchronization:
