Previous Topic

Next Topic

Inhoudsopgave

Book Index

SQL Server change tracking

Enable change tracking for the Isah database. You can enable this feature in SQL Server Management Studio by choosing the database properties for the Change Tracking option. Set Change Tracking to 'True' and set Retention Period to a minimum of three days.

The retention period is the period during which the SQL Server keeps the changes made to the tables. This period should not be too long, as the more data to be kept by the SQL Server, the larger the size of the database. A good rule of thumb is to set the retention period to three to seven days.

Then enable Change Tracking for all tables to be synchronized. You can use the Isah Mobile Config tool for this:

  1. Start Isah Mobile Config.
  2. In the main menu, choose Project, Open (or click the Open Project button on the toolbar) and log in to connect to the Isah database.
  3. In the navigation pane, open the Tables group and click the Change Tracking icon.

    All tables to be synchronized are now displayed; a marker indicates whether Change Tracking is enabled (green marker) or disabled (red marker) for the table in question.

  4. In the main menu, open the Change Tracking menu, and select Auto config to enable Change Tracking for all tables. All tables will now have a green marker.