Performing delta data migration

This section provides information about how to run the delta data migration. The following topics are covered in this section:

Guidelines for migrating the delta data

When you migrate the delta data, ensure that you adhere to the following guidelines:

• Use the same Admin user account to log in to both the servers. The upgrade environment is a database restore of the production environment. BMC recommends that you use one user to do this migration, which will help to track and debug issues. If you use Demo, ensure that you have the same password for both the servers for that Admin account.
• You can run the Delta Data Migration tool once or multiple times. BMC recommends that you run the tool at least twice---once before you start your production outage, and then a final time right after the production outage begins. The first data migration moves all of the data that has been added or changed since you made the production backup. The second migration moves only the data that has changed since you started the first data migration. This ensures that the time required to do the data migration (your outage window) is as small as possible.
• If you are using the multi-run approach to migration to minimize your downtime, ensure that the following check box is not selected: Re-run applications with previous criteria & instructions.

To migrate the delta data

1. Go to the C:\Program Files\BMC Software\Migrator\migrator\DeltaDataMigration directory.
   This is the default path.
   For more information on the package contents, see Delta Data Migration tool package contents.
2. Double-click the DeltaMigration.exe file.
   The Delta Migrations screen appears.

3. Click the button to the right of the Source Server field.

   Field	Description
   Source Server	This is the source server name (production server).
   User Name	This is the user name of the source server and destination servers. The user name should be the same.
   Password	This is the password of the source server and destination servers. The password should be the same.
   TCP Port	This is the default value used by the script . If no port is specified, the default is 0.
   Fast/List Port	The default port is 390635.

4. Specify the source server information in the dialog and click OK.
5. Open the Server dialog again by clicking the button to the right of the Destination Server field.

6. Specify the destination server (staging server) information and click OK.
   After you provide the source and destination server information, the Delta Data Migration Tool validates the versions on your source and destination servers and provides a list of all supported BMC Remedy AR System products and applications. Applications shown in red indicate that no appropriate package was found.
   
   

   Field or Button	Description
   Fetch Data/Objects Created/Modified After Date field	The timestamp from when you want to transfer the data. Data in the forms that are greater than or equal to this timestamp will be migrated.
   Compare (optional) button	This button optionally creates a comparison result report.This report can be used to identify all data that has been created and/or updated during the delta time period.
   Migrate button	This button starts the data migration. All delta data is transferred from the source server to the destination server.
   Delete (optional)	This button is optionally used if any records were deleted from the database rather than only deleted from the applications during the delta period. Any orphan data is removed from the staging server.
   Re-run applications with previous criteria & instructions check box	This check box is checked by default and should remain checked even if you are rerunning the migration after fixing any data issues.

7. Select the applications for which you want to migrate the delta data:
   • Check the following options for enterprise AR System:
     • BMC Remedy AR System
     • BMC Atrium CMDB
     • Remedy Foundation Product Catalog
     • BMC Atrium Integration Engine
     • ITSM Foundation
     • ITSM Asset Management
     • ITSM Service Desk
     • ITSM Change Management
     • BMC Service Level Management
     • BMC Service Request Management
     • BMC Remedy Knowledge Management
     • Integration For Remedy Service Desk
     • BMC_PN: Class and Attribute Definitions for Service Impact Management
     • SIM: Class and Attribute Definitions for Service Impact Management
     • BMC Cloud Management Foundation
     • BMC Cloud Management Administrator
     • BMC Cloud Management User
     • BMC Cloud Enterprise Atrium CMDB 
   • Uncheck the BMC Cloud Atrium CMDB option.
   • Check the following options for the Cloud database
     • BMC Remedy AR System
     • BMC Atrium CMDB
     • Remedy Foundation Product Catalog
     • BMC Atrium Integration Engine
     • BMC Cloud Atrium CMDB 
   • Uncheck the following options:
     • BMC Cloud Enterprise Atrium CMDB
     • BMC Cloud Management Foundation
     • BMC Cloud Management Administrator
     • BMC Cloud Management User

8. Select the appropriate applications that are not marked in red and provide the date and time when you want to migrate the data.

   Note

   If you are migrating the delta data for the first time, the timestamp of the production sever backup is used from when you set up the staging server. If this is a migration rerun scenario, the timestamp of the previous run is used.

9. If you are not migrating custom forms data, you can uncheck the custom selection in the Application Name list.
10. If you want to compare two or more forms to view the changes, click Compare. Otherwise, click Migrate.
    The DeltaMigration window appears with the parameters that will be used by the Delta Data Migration Tool.

11. Click Yes to continue.
    A command window is launched for each application that you are running. The windows close automatically when the process is done, or if there is an error. If you click No, the migration or comparison will be cancelled.

    If you want to re-run the migration or the comparison, you must wait for all of the command prompts windows to close before executing a new run. The command output will be available as an HTML log file.

To normalize the migrated delta data

After you migrate the delta data, you must run the migration scripts. The scripts normalizes the data that you migrated from BMC Cloud Lifecycle Management 2.1.x to 3.0. The scripts also converts the 2.1 data to a 3.0 compatible format. To perform data migration and normalization, see the To run data migration using the maintenance tool topic.

To execute the post delta data migration procedures

See the following BMC Remedy Action Request System online technical documentation topic for the steps to execute after you complete the final delta data migration:

Post-migration procedures

To find the delta data in production, use the AREntryCounter utility, as described in the BMC Remedy Action Request System online technical documentation:

Using the AREntryCounter utility