Specifying, starting, and viewing premigration assessment runs - AWS Database Migration Service
Specifying individual assessmentsStarting and viewing premigration assessment runs

Specifying, starting, and viewing premigration assessment runs

A premigration assessment specifies one or more individual assessments to run based on a new or existing migration task configuration. Each individual assessment evaluates a specific element of the source or target database depending on considerations such as the migration type, supported objects, index configuration, and other task settings, such as table mappings to identify the schemas and tables to migrate. For example, an individual assessment might evaluate what source data types or primary key formats can and cannot be migrated.

Specifying individual assessments

When creating a new assessment run, you can choose to run some or all of the individual assessments that are applicable to your task configuration.

AWS DMS supports premigration assessment runs for the following relational source and target database engines:

Starting and viewing premigration assessment runs

You can start a premigration assessment run for a new or existing migration task using the AWS DMS Management Console, the AWS CLI, and the AWS DMS API.

To start a premigration assessment run for a new or existing task

  1. From the Database migration tasks page in the AWS DMS Management Console, do one of the following:

    • To create a new task and assess it, choose Create task. The Create database migration task page opens:

      1. Enter the task settings required to create your task, including table mapping.

      2. In the Premigration assessment section, the Premigration assessment run checkbox is checked. This page contains the options to specify an assessment run for the new task.

      Note

      When creating a new task, enabling a premigration assessment run disables the option to start the task automatically on task creation. You can start the task manually after the assessment run completes.

    • To assess an existing task, choose the Identifier for an existing task on the Database migration tasks page. The task page for the chosen existing task opens:

      1. Choose Actions and select Create premigration assessment. A Create premigration assessment page opens with options to specify an assessment run for the existing task.

  2. Enter a unique name for your assessment run, or leave the default value.

  3. Select the available individual assessments that you want to include in this assessment run. You can only select the available individual assessments based on your current task settings. By default, all available individual assessments are enabled and selected.

  4. Search for and choose an Amazon S3 bucket and folder in your account to store your assessment result report. For information about setting up resources for assessment runs, see Creating prerequisites for premigration assessments.

  5. Select or enter an IAM role with full account access to your chosen Amazon S3 bucket and folder. For information about setting up resources for assessment runs, see Creating prerequisites for premigration assessments.

  6. Optionally choose a setting to encrypt the assessment result report in your Amazon S3 bucket. For information about S3 bucket encryption, see Setting default server-side encryption behavior for Amazon S3 buckets .

  7. Choose Create task for a new task or choose Create for an existing task.

    The Database migration tasks page opens listing your new or modified task with a Status of Creating... and a banner message indicating that your premigration assessment run will start once the task is created.

AWS DMS provides access to the latest and all prior premigration assessment runs using the AWS DMS Management Console, the AWS CLI, or the AWS DMS API.

To view results for the assessment run

  1. From the AWS DMS Management Console, choose the Identifier for your existing task on the Database migration tasks page. The task page for the existing task opens.

  2. Choose the Premigration assessments tab on the existing task page. This opens a Premigration assessments section on that page showing results of the the assessment runs, listed by name, in reverse chronological order. The latest result appears at the top of the list. Choose the name of the assessment run whose results you want to view.

These assessment run results start with the name of the latest assessment run and an overview of its status followed by a listing of the specified individual assessments and their status. You can then explore details of the status of each individual assessment by choosing its name in the list, with results available down to the table column level.

Both the status overview for an assessment run and each individual assessment shows a Status value. This value indicates the overall status of the assessment run and a similar status for each individual assessment. Following is a list of the Status values for the assessment run:

  • "cancelling" – The assessment run was cancelled.

  • "deleting" – The assessment run was deleted.

  • "failed" – At least one individual assessment completed with a failed status.

  • "error-provisioning" – An internal error occurred while resources were provisioned (during provisioning status).

  • "error-executing" – An internal error occurred while individual assessments ran (during running status).

  • "invalid state" – The assessment run is in an unknown state.

  • "passed" – All individual assessments have completed, and none has a failed status.

  • "provisioning" – Resources required to run individual assessments are being provisioned.

  • "running" – Individual assessments are being run.

  • "starting" – The assessment run is starting, but resources are not yet being provisioned for individual assessments.

  • "warning" – At least one individual assessment completed with a warning status.

Following is a list of the Status values for each individual assessment of the assessment run:

  • "cancelled" – The individual assessment was cancelled as part of cancelling the assessment run.

  • "error" – The individual assessment did not complete successfully.

  • "failed" – The individual assessment completed successfully with a failed validation result: view the details of the result for more information.

  • "invalid state" – The individual assessment is in an unknown state.

  • "passed" – The individual assessment completed with a successful validation result.

  • "pending" – The individual assessment is waiting to run.

  • "running" – The individual assessment is running.

  • "warning" – The individual assessment completed successfully with a warning validation result: view the details of the result for more information.

You can also view the JSON files for the assessment run results on Amazon S3.

To view the JSON files for the assessment run on Amazon S3

  1. From the AWS DMS Management Console, choose the Amazon S3 bucket link shown in the status overview of the assessment run. This displays a list of bucket folders and other Amazon S3 objects stored in the bucket. If your results are stored in a bucket folder, open the folder.

  2. You can find your assessment run results in several JSON files. A summary.json file contains the overall results of the assessment run. The remaining files are each named for an individual assessment that was specified for the assessment run, such as unsupported-data-types-in-source.json. These files each contain the results for the corresponding individual assessment from the chosen assessment run.

To start and view the results of premigration assessment runs for an existing migration task, you can run the following CLI commands and AWS DMS API operations: