All ServiceNow to Cherwell Templates

Foundation

(Release 1). This Template migrates Organisational data from Service Now into Cherwell.

It is intended as a framework to support your migration project.

If you have customised any tables or added new ones then you will need to modify/add the corresponding mappings to this project if you want the data in any custom fields to be included in the migration.

Incident, Problem and Change

(Release 1). This Template migrates Incident, Problem and Change request data from Service Now into Cherwell.

It should be run AFTER the migration of all foundation data (see separate template for this).

Project variables have been provided to allow migration of only closed or only open incident, problem and change records.

It is particularly important that TeamInfo and UserInfo records exist on the target server with the same name and email address fields as those on the target server. Attempts to migrate records referencing a missing user or team, or where the user does not belong to the specified team, will result in an error.

This template also includes mappings to create Services. Category and SubCategory entries in Cherwell from Business Service (cmdb_ci_service) records in Service Now.

This project assumes that a field named ExternalSystemID has been added to the following tables

If you wish to preserve the ServiceNow numbering for incidents, problems or changes, we recommend creating a custom field in the Cherwell equivalent tables to hold this value and mapping the number field to this. We do not recommend mapping to the Cherwell Incident/Problem/Change number field since this can lead to the corruption of the corresponding table.