To be able to synchronize all changes made to the Isah database with the mobile databases, SQL Server Change Tracking is extended for Isah ML. The following SQL scripts were installed in the folder you specified by the Isah Mobile Script Installer:
Create_Triggers_MT_CT_CycleCountDetail.sql
Create_Triggers_MT_CT_CycleCountMain.sql
Create_Triggers_MT_CT_DeliveryLine.sql
Create_Triggers_MT_CT_DossierDetail.sql
Create_Triggers_MT_CT_DossierMain.sql
Create_Triggers_MT_CT_Employee.sql
Create_Triggers_MT_CT_ProdBillOfMat.sql
Create_Triggers_MT_CT_ProdBillOfOper.sql
Create_Triggers_MT_CT_ProductionHeader.sql
Create_Triggers_MT_CT_PurchaseDocument.sql
Create_Triggers_MT_CT_PurDocExtOperLine.sql
Create_Triggers_MT_CT_PurDocPartLine.sql
These scripts create triggers for a number of Isah tables. They also ensure that any changes made to records that are relevant to the table filters (for instance because the change causes a record to fall outside of the filter range) are still processed correctly during the synchronization process of Isah ML. The scripts to be installed depend on the Isah ML functions you want to use.
Determine which of the above scripts you need and install them in the Isah database by executing them in SQL Server Management Studio.
Run the script 'Create_Cleanup_job_Isah_Change_Tracking_tables.sql'. This script creates a scheduled job in SQL Server which ensures that the custom change tracking tables are purged after some time. The retention period (the time the changes are kept) is the same as the change tracking retention period set for the Isah database.
