Run the Site Merge Utility

You can run the utility by using the SiteMerge.exe file. Running the utility transfers data from the source database to the destination database. For the utility to run effectively, ensure that you resolve all the merge conflicts.

Before You Begin

• From the Installation media, navigate to the Utility folder and create a copy of SiteMerge folder in your machine.

• We recommend having source and destination databases on same server to avoid memory and performance problems.

• Before running the Site Merge Utility, you must run the following two SQL scripts on the database. The scripts are available in \SiteMergeUtility\SQLScripts folder.

  • SiteMergeAuditTrail_Table.sql: You must run this script on the target database. This script creates two tables in the database, SiteMergeResolutionAuditTrail and SiteMergeSqlTraceAuditTrail, that captures the resolutions and the SQL scripts used. For more information, see the topic Audit Trail .

    If you run the utility with low or restricted privilege that does not have a permission to create a table in the database, then the database administrator must run the script at the target database to create the tables.

  • SiteMergeExcludedId_Table.sql: This script creates a temporary table in the source database for transit data during Site Merge operation. This table gets deleted when you close the utility.

    If you run the utility with low or restricted privilege that does not have a permission to create a table in the database, then the database administrator must run the script at the source database to create the table and then manually delete the table after closing the Site Merge Utility.

• Make sure that you read and understand the information provided in the topic Important points to consider for tables before performing the merge.

You can perform the following steps to run the Site Merge Utility against the database.

Steps:

1. From the SiteMerge folder, double-click SiteMerge.exe.

   The Mobile Operator Database Merge Utility window appears, displaying the Welcome screen.

2. Click Next.

3. In the Select Flat File Directory, click Browse to select the output file destination of the results.

4. In the Date from box, select the date from when you want to transfer the data to the destination database, and then select Next.

   The transactional data from the UTC midnight of the selected date till the current date will be migrated to destination database. For example, if the date selected is ‘2021-01-01’, then the UTC midnight for same will be ‘2021-01-01 00:00:00.0000+00:00’.
   The time to migrate the data depends on the size of transactional data. The transactional data in the following tables of the database will be migrated:

   • SAT_TRANS_DATA_GROUP

   • SAT_TRANS_DATA_ITEM

   • SAT_Trans_Attachments

   • ISMGT_TRANSMITTED_PROFILE

   • SAT_Procedure_Integrations_TransData

   • SATT_COR_TRANS_SEVERITY_ROLLUP

   • SAT_Notes

   The Setup Source Connection screen appears.

5. Enter the following source database details and select Test Connection.

   1. Server Name: The name of the server that contains the source database.

   2. Database Name: The name of the database that you want to merge to the destination database.

   3. Authentication: Select the required authentication: WindowsAuthentication or SQLServerAuthentication.

      NOTE: If you are using SQLServerAuthentication, then provide the Login and Password details.

6. If the connection is successful, the Next button is enabled. Click Next.

   The Setup Target Connection screen appears.

7. Enter the destination database details as provided for the source database in step 5 and select Test Connection.

8. If the connection is successful, the Next button is enabled. Click Next.

   If there is a conflict in the tables, then the Merge screen for the tables appear, displaying the conflicts.

   

9. Resolve the conflicts. For more information on resolution, see the topic Resolve merge conflicts . On resolving the conflicts, the Next button appears.

   Once the conflicts are resolved, the Review screen appears.

10. Select Run Merge.

    The list of the tables and a confirmation message appears, indicating that the merge was successful.

    After the successful merge, it is recommended to perform the index rebuild or reorganization (defragmentation) in the target database.