Commissioning is a process where the existing SQL Server database gets emptied of all test data, and prepared for accepting data from live systems as you switch over to the new systems.

In order to provide maximum efficiency the system will allow you to drop existing checks, indexes and relationships, and after the data has been migrated re-create the indexing, checks and relationships.

Additional automatic checks are performed on the live systems, to verify that no data problems exist; such as illegal dates. If problems are found, then MUST will provide details on all data issues and if desired automatically purify the illegal field values setting them to a safe default.

MUST allows you to refresh record counts in each Access table, which is important as the final step in commissioning is to check that the number of rows in each Access table matches the number of rows in each SQL Server table. MUST will warn you if the record counts do not match and list any table with discrepencies.