Documentation relating to release 3.8

Use the links below to navigate to your topic area of interest

Introduction
Audience and Scope
Definitions
Pre-Requisites
Launching & Licensing
Initial Configuration
Opening an Existing Migration Project
Opening a Recent Project
Configuring an Oracle Database Source
Configuring a SQL Server Database Source
Creating a New Migration Project
Creating a New Template Project
Creating a Migration Project from a Template
Using File Save, Save As, Move and Rename Options
File->Save Option
File->Save-As Option
File->Move Option
File->Rename Option
Entering Project Notes
Creating a New Mapping
Mapping to Virtual Tables
Managing the Mappings List
Creating a New Form Mapping from the Mappings List
Changing the Order of the Mappings List
Deleting a Form Mapping from the Mappings List
Changing the Mapping Identifier
Enabling and Disabling Form Mappings
Defining Field Mappings
Creating a new Simple Field Mapping
Creating a new Assignment Field Mapping
Creating a new Value Match Field Mapping
Creating a new Reference Field Mapping
Notes on use of Key Mapping in Reference Field Mappings    47
Creating a new Lookup Field Mapping    48
Creating a new ID List Mapping    50
Creating ID List Field Mappings using String Fields or Temporary Variables    52
Generating Default Mappings    53
Updating an Existing Field Mapping    54
Creating temporary variables    56
Using temporary variables in expressions    57
Defining Key Mappings    59
Controlling Multiple-Match Behaviour    62
Additional Key Mapping Options    62
Notes on use of Key Mappings    63
Restricting Source Records (Source Filtering)    65
Filtering Records Using a Query    65
Using the Source Count button    68
Usage of Source Filtering Query when Source Server Type is ServiceNow    68
Filtering By Inclusion    70
Filtering By Inclusion Using an Ad-Hoc Query    71
Defining Lookup Queries    73
Defining Source Lookup Queries    73
Defining Target Lookup Queries    74
Usage of Lookup Queries when Target Server Type is ServiceNow    77
Usage of Lookup Queries when Source Server Type is ServiceNow    78
Usage of Lookup Queries when Source or Target Server Type is ServiceNow    78
Optimising Lookup Queries for best performance    79
Defining Record Delete Conditions    80
Deleting Records based on Target Scope Query    81
Deleting Records based on Unmatched Records    82
Additional Form Mapping Options    85
Defining Project Variables    87
Execution Options    90
Defining Execution Variable Values    90
Defining Execution Migration Options    91
Defining Execution Logging Options    93
Notes on Execution Logging    93
Defining Execution Migration Report Options    94
Note on Recoverable Errors    94
Defining Advanced Migration Options    95
Reporting    97
Difference Report (for BMC Remedy servers only)    97
Target Count Report    102
Migration Reports    102
Project Logging    106
Restricting Migrations to Non-Business Hours    108
Defining Restrictions for Form Mappings    108
Defining Business Hours for the Project    108
Migrating Attachments    110
Migrating BMC Remedy Attachments to another BMC Remedy server    110
Migrating ServiceNow Attachments to another ServiceNow instance    110
Migrating BMC Remedy Attachments to a ServiceNow instance    111
Notes on migrating attachments to a ServiceNow instance    112
Notes on migrating large attachments to a ServiceNow instance    112
Adding Notes to Form Mappings    113
Appendix A:  Functions available for building Expressions in Assignment Mappings    114
Appendix B:  Unsupported Field Types    122
Appendix C:  Migration of Currency Fields    122
Appendix D:  Migration of Journal and Diary Fields    124
Appendix E:  Migration of ServiceNow Duration Fields    126
Appendix F:  Migration of Images    127
Migrating images between BMC Remedy servers    127
Migrating images from BMC Remedy to ServiceNow    127
Migrating images between ServiceNow instances    127
Appendix G:  Restrictions on use of Oracle DB data source    128