Administer > Delta Migration Tool > Installing the delta migration tool > Prerequisites for using delta migration tool

Prerequisites for using the delta migration tool

Before you use the delta migration tool to migrate the delta data, the following prerequisites must be met.

Note Only the first requirement applies to both method 1 and method 2, while the other four requirements apply only to method 2.

  • Make sure that the new Service Manager system is clean and does not contain any test records.

    Before the delta migration, the new Service Manager system should include only the records or modifications from the original system. You must remove any test data that was created or modified on the new system during the delta data period.

    If there are some test records added to the new system during the delta data period, as shown in the following figure, then the delta data from the original Service Manager system cannot be migrated to the new system because of a data conflict. Even if you decide to use the delta data from the original Service Manager system to overwrite the test records, there is a risk of a data integrity violation.

    For example, a new incident IM12345 (called IM_A) is created in the original system during delta data period, and another test record IM12345 (called IM_B) is created in the new system, with several activity logs. If you then use IM_A in the original system to overwrite IM_B in the new system, you will find that IM_A in the new system contains some incorrect activity logs, which belong to IM_B.

  • Make sure that the date format of the original Service Manager system does not have the y2k problem. To do this, follow these steps:

    1. Open System Navigator > Base System Configuration > Miscellaneous > System Information Record.
    2. Go to Data Info.
      If the date format contains only two digits for the year value, such as "mm/dd/yy", change it to four digits (for example, "mm/dd/yyyy").
    3. Save the modification and restart the Service Manager service.
  • Create a new administrator's account in the original Service Manager system. The date format and time zone settings of this account should be the same as those in System Information Record.

    Because background tasks will use the default time zone and date format in the System Information Record, creating a new admin account with the same time zone setting and date format of System Information Record will avoid missing data.

  • Make sure that the five background schedulers (bg_load_unload 1, ..., bg_load_unload 5) have been started in both of the Service Manager systems. If the background schedulers haven been started, they should be visible in the System Status record. If they are not there, click Start Scheduler and select dmt.unload.load.

  • Make sure that an empty folder is created on the original Service Manager system for exporting the delta data.

Related topics

Delta migration tool
Delta migration methods

Installing the delta migration tool
Method 1: Manually export/import a single UNL file
Method 2: Automatically export/import multiple UNL files

Troubleshooting delta migration