Using BMC BladeLogic Data Migration Manager

You can use BMC BladeLogic Data Migration Manager to simplify and automate the data migration process.

In addition to running the data migration, you can:

• Use BMC BladeLogic Data Migration Manager to check that your environment is ready for a data migration without actually running the migration.
• Access logs from the current environment checks and migrations or from the last BMC BladeLogic Data Migration Manager session.

From the BMC BladeLogic Data Migration Manager console, you can determine the following information:

• Current version of the database
• Migration path to be executed
• Status of the environment check
• Status of the data migration

You can perform the following tasks:

• Validate your environment to ensure that it is ready for the database migration (Oracle only)
  For more information, see To validate Oracle environments.
• Run the database migration (this task automatically validates your environment before starting the migration)
  For more information, see To run data migrations.
• Track the progress of the validation and migration tasks
• Get estimates on the amount of the time required for migration
• View results from verifications or migrations launched from the current BMC BladeLogic Data Migration Manager session or from the previous session
  For more information, see To view results and To view results from previous sessions.
• Export logs
  For more information, see To export logs.
• Restart a data migration if a previous attempt did not run to completion

The following sections describe using Data Migration Manager:

To validate Oracle environments

From the BMC BladeLogic Data Migration Manager console, click Validate Environment.

The progress of the environment check displays in the results table in the Migration progress area of the console. When the execution of the tasks completes, a message with the overall status of the validation is displayed, and the result of the validation check (whether it passed or failed) is shown next to the Environment check label in the Migration status area of the console.

For more information on viewing the results, see To view results. If the validation completed successfully and you want to run the migration, see To run data migrations.

To run data migrations

From the BMC BladeLogic Data Migration Manager console, click Run Migration or Continue Migration.

To view results

BMC BladeLogic Data Migration Manager displays the results of an environment check or a database migration in the results table. Each row corresponds to a main task. The following information is available for each task:

In addition, you can access the task details (see To access subtasks), the full log including all of the tasks (not just the main tasks), or a set of subtasks for a particular main task (see To view the full log for a validation check or migration).

To access subtasks

To access subtasks from the results table, perform one of the following actions:

• Double-click a main task row.
• Click Task Details
  .
  The log for the task appears in a new window in the same format as the results table described in To view results

To view the full log for a validation check or migration

1. Click Show Log.
   The full log for the validation or migration appears in a new window in the same format as the results table described in To view results.
2. From the Task Log window, you can perform any of the following actions:
   • Export the log (see To export logs).
   • Limit the information that is displayed as follows. To exclude the:
     • Success messages in the log, remove the check mark from Show Information.
     • Warning messages in the log, remove the check mark from Show Warnings.
     • Error messages in the log, remove the check mark from Show Errors.
   • Close the window by clicking Close.

To copy text from the results table or log window to the Clipboard

1. In the results table or a log window, select one or more lines of textual information.
2. Right-click and select Copy to Clipboard from the pop-up menu.

After you copy the text to the clipboard, you can paste it into a document or spreadsheet.

To export logs

1. From a log window, click Export Log
   .
2. For Object Name, provide a file name and location in which you want to store the exported results log.
3. From File encoding, select the type of character encoding that should be used for the exported data, such as UTF-8 or UTF-16.
4. Click Save.
   A message confirms that the export is complete.

To view results from previous sessions

Launch BMC BladeLogic Data Migration Manager by entering one of the following commands:

• (Microsoft Windows) blmigration_mgr.exe <path_to_migration_directory>
• (Linux and UNIX) ./blmigration_mgr <path_to_migration_directory>

Where <path_to_migration_directory> is the path to the migration directory that you copied to the Application Server in step 3 of Migrating an Oracle database or Migrating an SQL database. For example, if you extracted the version 8.2 SP1 externalfiles.zip file under the tmp directory, then the path to the migration directory would be:

• (Microsoft Windows) blmigration_mgr.exe C:\tmp\release_8.2.0_dev-266-external-files\bl_8.2.01\db_scripts\<dbType>\upgrade
• (Linux and UNIX) ./blmigration_mgr /tmp/release_8.2.0_dev-266-external-files/bl_8.2.01/db_scripts/<dbType>/upgrade/
  Where <dbType> is either oracle or sqlserver.

If you have already completed the data migration in a previous BMC BladeLogic Data Migration Manager session, a warning stating that there is no migration path from the current version appears.

The console opens with the log options enabled and the other options disabled.

For information on viewing the results, see To view results.

Data migration process

For an upgrade of BMC Server Automation, you use the BMC BladeLogic Data Migration Manager to perform the data migration of your Oracle or SQL Server database. When you run data migration, the BMC BladeLogic Data Migration Manager takes the following actions:

1. Creates the stored tasks needed for the migration.
2. Executes the environment validation tasks.
3. If the validation is successful, starts running the migration tasks.
   In the case where you are continuing a migration that had previously not run to completion, BMC BladeLogic Data Migration Manager continues the migration from the last completed step. The progress of the tasks displays in the results table in the Migration progress area of the console.
4. If the migration path includes multiple versions, the version being updated is highlighted in bold in the Migration path section of the Migration status area of the console. When the migration for each version completes, BMC BladeLogic Data Migration Manager moves on to the next. For each version in the migration path, it:
   1. Creates the necessary stored tasks.
   2. Executes the environment validation tasks.
   3. If the validation is successful, starts running the migration tasks for that version.
   4. The log is reset as each migration commences.
5. When the execution of all the tasks completes, a message with the overall status of the migration displays, and the result of the migration (whether it passed or failed) is shown next to the Migration result label in the Migration status area of the console.

For more information on viewing the results, see To view results.