Running the synchronization SQL script

If you choose to synchronize phone numbers and e-mail addresses, you must run the Run Name_Address to Name Global Sync resynchronization SQL script located on the System Reports and Queries window (select Utilities > Reports and Queries, select Table Maintenance from the Report Types list, and select the Run Name_Address to Name Global Sync report). This script updates all existing records in the iMIS database based on the values you entered in the synchronized fields.

You must be logged into iMIS as the database administrator (dba or sa) to run this script. If the Name_Address field is not blank and is different than the Name field, a change log entry is created for each Name record changed. If multiple changes are made for a given Name record, there is a separate log entry for each field.

You must run the resynchronization SQL script every time a change is made to any of the Synchronize Phone Numbers & Email fields, except when changing a value to None. You must restart iMIS after running the synchronization SQL script.