Step11: Migrate Process Designer data

You can use the data migration tool to migrate data from legacy process records to new process records within the same Service Manager system. It is not used to migrate data across different Service Manager systems. You can configure the migration tool from the GUI, and it requires administrator privileges.

The migration tool allows an operator to configure the field/value mapping between two files. It also covers customized fields. The out-of-box Process Designer provides several sample migration scripts that you can choose to use according to your migration scenario.

Caution During data migration, there are no dependencies between the modules, however the scripts for each specific module must be executed in the listed order.

Module Script
PD Framework
  1. Legacy change model taskplanner data to new taskplanner
  2. Legacy change instance taskplanner data to new taskplanner
  3. Legacy change/task data to new taskplanner

Problem
  1. Legacy problem to new problem
  2. Legacy problem task to new problem task
  3. Legacy known error to new known error
  4. Legacy Process Designer known error to new Process Designer known error

  5. Legacy known error related record migration
  6. Legacy known error attachment to new known error attachment
Service Level Agreement
  1. Legacy SLA to new Agreement
Service Catalog
  1. Legacy Catalog Items to new Catalog Items
Configuration Item
  1. Legacy configuration item to new configuration item

If further migrations are needed, an administrator can use these samples to define their own. Considering that some tables typically have a large data volume, the Data Migration tool supports an SQL batch update mode to ensure good performance.

Note We recommend  that you back up the production data before migration.

Run the scripts for specific modules as follows:

Module 9.3x non PD 9.3x PD3 9.3x PD4 9.40 Classic / 9.41 Classic 9.40 Codeless / 9.41 Hybrid / 9.41 Codeless 9.50 Codeless / 9.50 Hybrid / 9.51 Codeless / 9.51 Hybrid
PD Framework Legacy change model taskplanner data to new taskplanner        
Legacy change instance taskplanner data to new taskplanner        
Legacy change/task data to new taskplanner        
Problem Legacy problem to new problem      
Legacy problem task to new problem task      
Legacy known error to new known error      
Legacy PD known error to new PD known error          
Legacy known error related record migration      
Legacy known error attachment to new known error attachment      
Service Level Agreement Legacy SLA to new Agreement      
Service Catalog Legacy Catalog Items to new Catalog Items  
Configuration Item Legacy configuration item to new configuration item

How to run a migration script

Note If you are upgrading an existing Service Manager system to Process Designer, you need to customize the legacy out-of-box migration script samples for your specific environment.

To run a migration script, follow these steps:

  1. Type db in the command line to open Database Manager.

  2. Type migrationSetting in the Table field, and then click Search.

  3. In the Migration Script setting detail form, click Migrate Data to run the migration script.

  4. When using the Batch Update mode, the Data Migration pop-up window shows the RDBMS SQL Statements that will be run on the database. Check that the SQL statements are correct, and change these SQL statements if needed. Click Next, and then click Finish to start the migration in Batch Update mode.

    Note If there is no data to migrate, or if the data is already migrated, you receive the following notification: 

    "No records match the filter condition. At least one matching record is required."