Setting the file. One moment.
Chapter 77 · Dms Schema Conversion
Subchapter 77.3
references/schema-conversion-operations.mdMarkdown7 KBView on GitHub
* The cancel API call returns synchronously, but the cancellation state transition is async (
CANCEL_RECEIVED→CANCELING→CANCELED). Use the corresponding waiter to confirm the operation reached theCANCELEDstate.Note: All waiters require
--filter 'Name=schema-conversion-operation-id,Values=<RequestId>'in addition to--migration-project-identifier.
For full parameter details and examples, refer to the linked CLI documentation for each command.
Use DMS waiters to wait for async operations to complete:
| Operation | Waiter command |
|---|---|
| Import | aws dms wait metadata-model-imported |
| Conversion | aws dms wait metadata-model-converted |
| Assessment | aws dms wait metadata-model-assessed |
| Creation (statement) | aws dms wait metadata-model-created |
| Export as script | aws dms wait metadata-model-exported-as-script |
| Export to target | aws dms wait metadata-model-exported-to-target |
| Cancel conversion | aws dms wait metadata-model-conversion-cancelled |
| Cancel creation | aws dms wait metadata-model-creation-cancelled |
| Extension pack | aws dms wait extension-pack-associated |
Documentation: https://docs.aws.amazon.com/cli/latest/reference/dms/wait/index.html (opens in a new tab)
All async operations use the same status values:
| Status | Meaning |
|---|---|
RECEIVED | Request received, queued |
IN_PROGRESS | Operation is running |
SUCCESS | Operation completed successfully |
FAILED | Operation failed — check error details |
CANCEL_RECEIVED | Cancellation request received |
CANCELING | Cancellation in progress |
CANCELED | Operation was cancelled |
RETRY | Operation is being retried |
PENDING | Operation is pending |
start-* → extract RequestIdentifieraws dms wait command (see DMS Waiters table)Invalid choice due to outdated CLI) → fall back to manual polling with the corresponding describe-* command until status reaches SUCCESS or FAILEDFallback polling pattern (use when waiter is not available):
aws dms describe-metadata-model-<operation>s \
--migration-project-identifier <migration_project_identifier> \
--filter Name=request-id,Values=<RequestIdentifier>Check Requests[0].Status — repeat every 30 seconds until it reaches SUCCESS or FAILED.
Constraint: You MUST NOT proceed to the next step until the operation has completed. If the waiter fails or times out, you MUST fall back to polling with the describe command. Never assume an operation succeeded without confirming its status.
describe-metadata-model returns TargetMetadataModels with target SelectionRules — use these to query the TARGET tree (do NOT reuse source selection rules for target)describe-metadata-model-children returns MetadataModelChildren[] with MetadataModelName and SelectionRules — use the child’s SelectionRules to drill deeperexport-metadata-model-assessment is synchronous — returns S3 links immediately (PdfReport.S3ObjectKey, CsvReport.S3ObjectKey)start-metadata-model-creation only supports SQL Server → PostgreSQL/Aurora PostgreSQL