System of Record

Following are the points to consider for System of Records:

• System of Records (SOR) are a combination of Application ID and Application Item ID. They must be unique within the database table (For example, all assets must have a distinct SOR in the SAT_Assets table or all response lists must have distinct SOR in the SAT_Response_Lists table).

  NOTE: You must be careful when making changes in the System of Records as it will impact the entire application.

• When System of Records between the source and target data are equal, the Duplicate SOR error appears. You must manually resolve the duplicate System of Records conflict before processing the next table. If you have source and database on the same machine, do the following to resolve the error:

  1. Do not close the Site Merge utility.

  2. Open the folder Sql Scripts.

  3. Copy the content of the script xyz_SOR_SameDataSource.sql where xyz is the name of the data type (For example, ResponseList_SOR_SameDataSource.sql for response list data).

  4. Paste the content as a new script in SQL Server Management Studio.

  5. Change %SourceDatabase% to the source database name and %TargetDatabase% to the target database name.

  6. Execute the script for source and target primary keys.

  7. Locate those data rows and update their Application Item ID in the databases to make them distinct.

  8. Restart the Site Merge utility.