amazonaws.com – dms
Database Migration Service
Database Migration Service (DMS) can migrate your data to and from the most widely used commercial and open-source databases such as Oracle, PostgreSQL, Microsoft SQL Server, Amazon Redshift, MariaDB, Amazon Aurora, MySQL, and SAP Adaptive Server Enterprise (ASE). The service supports homogeneous migrations such as Oracle to Oracle, as well as heterogeneous migrations between different database platforms, such as Oracle to MySQL or SQL Server to PostgreSQL.
For more information about DMS, see in the Database Migration Service User Guide.
- Homepage
- https://api.apis.guru/v2/specs/amazonaws.com:dms/2016-01-01.json
- Provider
- amazonaws.com:dms / dms
- OpenAPI version
- 3.0.0
- Spec (JSON)
- https://api.apis.guru/v2/specs/amazonaws.com/dms/2016-01-01/openapi.json
- Spec (YAML)
- https://api.apis.guru/v2/specs/amazonaws.com/dms/2016-01-01/openapi.yaml
Tools (71)
Extracted live via the executor SDK.
-
xAmzTargetAmazonDmSv20160101AddTagsToResource.addTagsToResourceAdds metadata tags to an DMS resource, including replication instance, endpoint, subnet group, and migration task. These tags can also be used with cost allocation reporting to track cost associated with DMS resources, or used in a Condition statement in an IAM policy for DMS. For more information, see data type description.
-
xAmzTargetAmazonDmSv20160101ApplyPendingMaintenanceAction.applyPendingMaintenanceActionApplies a pending maintenance action to a resource (for example, to a replication instance).
-
xAmzTargetAmazonDmSv20160101BatchStartRecommendations.batchStartRecommendationsStarts the analysis of up to 20 source databases to recommend target engines for each source database. This is a batch version of .
The result of analysis of each source database is reported individually in the response. Because the batch request can result in a combination of successful and unsuccessful actions, you should check for batch errors even when the call returns an HTTP status code of
200. -
xAmzTargetAmazonDmSv20160101CancelReplicationTaskAssessmentRun.cancelReplicationTaskAssessmentRunCancels a single premigration assessment run.
This operation prevents any individual assessments from running if they haven't started running. It also attempts to cancel any individual assessments that are currently running.
-
xAmzTargetAmazonDmSv20160101CreateEndpoint.createEndpointCreates an endpoint using the provided settings.
For a MySQL source or target endpoint, don't explicitly specify the database using the
DatabaseNamerequest parameter on theCreateEndpointAPI call. SpecifyingDatabaseNamewhen you create a MySQL endpoint replicates all the task tables to this single database. For MySQL endpoints, you specify the database only when you specify the schema in the table-mapping rules of the DMS task. -
xAmzTargetAmazonDmSv20160101CreateEventSubscription.createEventSubscriptionCreates an DMS event notification subscription.
You can specify the type of source (
SourceType) you want to be notified of, provide a list of DMS source IDs (SourceIds) that triggers the events, and provide a list of event categories (EventCategories) for events you want to be notified of. If you specify both theSourceTypeandSourceIds, such asSourceType = replication-instanceandSourceIdentifier = my-replinstance, you will be notified of all the replication instance events for the specified source. If you specify aSourceTypebut don't specify aSourceIdentifier, you receive notice of the events for that source type for all your DMS sources. If you don't specify eitherSourceTypenorSourceIdentifier, you will be notified of events generated from all DMS sources belonging to your customer account.For more information about DMS events, see in the Database Migration Service User Guide.
-
xAmzTargetAmazonDmSv20160101CreateFleetAdvisorCollector.createFleetAdvisorCollectorCreates a Fleet Advisor collector using the specified parameters.
-
xAmzTargetAmazonDmSv20160101CreateReplicationInstance.createReplicationInstanceCreates the replication instance using the specified parameters.
DMS requires that your account have certain roles with appropriate permissions before you can create a replication instance. For information on the required roles, see . For information on the required permissions, see .
-
xAmzTargetAmazonDmSv20160101CreateReplicationSubnetGroup.createReplicationSubnetGroupCreates a replication subnet group given a list of the subnet IDs in a VPC.
The VPC needs to have at least one subnet in at least two availability zones in the Amazon Web Services Region, otherwise the service will throw a
ReplicationSubnetGroupDoesNotCoverEnoughAZsexception. -
xAmzTargetAmazonDmSv20160101CreateReplicationTask.createReplicationTaskCreates a replication task using the specified parameters.
-
xAmzTargetAmazonDmSv20160101DeleteCertificate.deleteCertificateDeletes the specified certificate.
-
xAmzTargetAmazonDmSv20160101DeleteConnection.deleteConnectionDeletes the connection between a replication instance and an endpoint.
-
xAmzTargetAmazonDmSv20160101DeleteEndpoint.deleteEndpointDeletes the specified endpoint.
All tasks associated with the endpoint must be deleted before you can delete the endpoint.
-
xAmzTargetAmazonDmSv20160101DeleteEventSubscription.deleteEventSubscriptionDeletes an DMS event subscription.
-
xAmzTargetAmazonDmSv20160101DeleteFleetAdvisorCollector.deleteFleetAdvisorCollectorDeletes the specified Fleet Advisor collector.
-
xAmzTargetAmazonDmSv20160101DeleteFleetAdvisorDatabases.deleteFleetAdvisorDatabasesDeletes the specified Fleet Advisor collector databases.
-
xAmzTargetAmazonDmSv20160101DeleteReplicationInstance.deleteReplicationInstanceDeletes the specified replication instance.
You must delete any migration tasks that are associated with the replication instance before you can delete it.
-
xAmzTargetAmazonDmSv20160101DeleteReplicationSubnetGroup.deleteReplicationSubnetGroupDeletes a subnet group.
-
xAmzTargetAmazonDmSv20160101DeleteReplicationTask.deleteReplicationTaskDeletes the specified replication task.
-
xAmzTargetAmazonDmSv20160101DeleteReplicationTaskAssessmentRun.deleteReplicationTaskAssessmentRunDeletes the record of a single premigration assessment run.
This operation removes all metadata that DMS maintains about this assessment run. However, the operation leaves untouched all information about this assessment run that is stored in your Amazon S3 bucket.
-
xAmzTargetAmazonDmSv20160101DescribeAccountAttributes.describeAccountAttributesLists all of the DMS attributes for a customer account. These attributes include DMS quotas for the account and a unique account identifier in a particular DMS region. DMS quotas include a list of resource quotas supported by the account, such as the number of replication instances allowed. The description for each resource quota, includes the quota name, current usage toward that quota, and the quota's maximum value. DMS uses the unique account identifier to name each artifact used by DMS in the given region.
This command does not take any parameters.
-
xAmzTargetAmazonDmSv20160101DescribeApplicableIndividualAssessments.describeApplicableIndividualAssessmentsProvides a list of individual assessments that you can specify for a new premigration assessment run, given one or more parameters.
If you specify an existing migration task, this operation provides the default individual assessments you can specify for that task. Otherwise, the specified parameters model elements of a possible migration task on which to base a premigration assessment run.
To use these migration task modeling parameters, you must specify an existing replication instance, a source database engine, a target database engine, and a migration type. This combination of parameters potentially limits the default individual assessments available for an assessment run created for a corresponding migration task.
If you specify no parameters, this operation provides a list of all possible individual assessments that you can specify for an assessment run. If you specify any one of the task modeling parameters, you must specify all of them or the operation cannot provide a list of individual assessments. The only parameter that you can specify alone is for an existing migration task. The specified task definition then determines the default list of individual assessments that you can specify in an assessment run for the task.
-
xAmzTargetAmazonDmSv20160101DescribeCertificates.describeCertificatesProvides a description of the certificate.
-
xAmzTargetAmazonDmSv20160101DescribeConnections.describeConnectionsDescribes the status of the connections that have been made between the replication instance and an endpoint. Connections are created when you test an endpoint.
-
xAmzTargetAmazonDmSv20160101DescribeEndpoints.describeEndpointsReturns information about the endpoints for your account in the current region.
-
xAmzTargetAmazonDmSv20160101DescribeEndpointSettings.describeEndpointSettingsReturns information about the possible endpoint settings available when you create an endpoint for a specific database engine.
-
xAmzTargetAmazonDmSv20160101DescribeEndpointTypes.describeEndpointTypesReturns information about the type of endpoints available.
-
xAmzTargetAmazonDmSv20160101DescribeEventCategories.describeEventCategoriesLists categories for all event source types, or, if specified, for a specified source type. You can see a list of the event categories and source types in in the Database Migration Service User Guide.
-
xAmzTargetAmazonDmSv20160101DescribeEvents.describeEventsLists events for a given source identifier and source type. You can also specify a start and end time. For more information on DMS events, see in the Database Migration Service User Guide.
-
xAmzTargetAmazonDmSv20160101DescribeEventSubscriptions.describeEventSubscriptionsLists all the event subscriptions for a customer account. The description of a subscription includes
SubscriptionName,SNSTopicARN,CustomerID,SourceType,SourceID,CreationTime, andStatus.If you specify
SubscriptionName, this action lists the description for that subscription. -
xAmzTargetAmazonDmSv20160101DescribeFleetAdvisorCollectors.describeFleetAdvisorCollectorsReturns a list of the Fleet Advisor collectors in your account.
-
xAmzTargetAmazonDmSv20160101DescribeFleetAdvisorDatabases.describeFleetAdvisorDatabasesReturns a list of Fleet Advisor databases in your account.
-
xAmzTargetAmazonDmSv20160101DescribeFleetAdvisorLsaAnalysis.describeFleetAdvisorLsaAnalysisProvides descriptions of large-scale assessment (LSA) analyses produced by your Fleet Advisor collectors.
-
xAmzTargetAmazonDmSv20160101DescribeFleetAdvisorSchemaObjectSummary.describeFleetAdvisorSchemaObjectSummaryProvides descriptions of the schemas discovered by your Fleet Advisor collectors.
-
xAmzTargetAmazonDmSv20160101DescribeFleetAdvisorSchemas.describeFleetAdvisorSchemasReturns a list of schemas detected by Fleet Advisor Collectors in your account.
-
xAmzTargetAmazonDmSv20160101DescribeOrderableReplicationInstances.describeOrderableReplicationInstancesReturns information about the replication instance types that can be created in the specified region.
-
xAmzTargetAmazonDmSv20160101DescribePendingMaintenanceActions.describePendingMaintenanceActionsFor internal use only
-
xAmzTargetAmazonDmSv20160101DescribeRecommendationLimitations.describeRecommendationLimitationsReturns a paginated list of limitations for recommendations of target Amazon Web Services engines.
-
xAmzTargetAmazonDmSv20160101DescribeRecommendations.describeRecommendationsReturns a paginated list of target engine recommendations for your source databases.
-
xAmzTargetAmazonDmSv20160101DescribeRefreshSchemasStatus.describeRefreshSchemasStatusReturns the status of the RefreshSchemas operation.
-
xAmzTargetAmazonDmSv20160101DescribeReplicationInstances.describeReplicationInstancesReturns information about replication instances for your account in the current region.
-
xAmzTargetAmazonDmSv20160101DescribeReplicationInstanceTaskLogs.describeReplicationInstanceTaskLogsReturns information about the task logs for the specified task.
-
xAmzTargetAmazonDmSv20160101DescribeReplicationSubnetGroups.describeReplicationSubnetGroupsReturns information about the replication subnet groups.
-
xAmzTargetAmazonDmSv20160101DescribeReplicationTaskAssessmentResults.describeReplicationTaskAssessmentResultsReturns the task assessment results from the Amazon S3 bucket that DMS creates in your Amazon Web Services account. This action always returns the latest results.
For more information about DMS task assessments, see in the Database Migration Service User Guide.
-
xAmzTargetAmazonDmSv20160101DescribeReplicationTaskAssessmentRuns.describeReplicationTaskAssessmentRunsReturns a paginated list of premigration assessment runs based on filter settings.
These filter settings can specify a combination of premigration assessment runs, migration tasks, replication instances, and assessment run status values.
This operation doesn't return information about individual assessments. For this information, see the
DescribeReplicationTaskIndividualAssessmentsoperation. -
xAmzTargetAmazonDmSv20160101DescribeReplicationTaskIndividualAssessments.describeReplicationTaskIndividualAssessmentsReturns a paginated list of individual assessments based on filter settings.
These filter settings can specify a combination of premigration assessment runs, migration tasks, and assessment status values.
-
xAmzTargetAmazonDmSv20160101DescribeReplicationTasks.describeReplicationTasksReturns information about replication tasks for your account in the current region.
-
xAmzTargetAmazonDmSv20160101DescribeSchemas.describeSchemasReturns information about the schema for the specified endpoint.
-
xAmzTargetAmazonDmSv20160101DescribeTableStatistics.describeTableStatisticsReturns table statistics on the database migration task, including table name, rows inserted, rows updated, and rows deleted.
Note that the "last updated" column the DMS console only indicates the time that DMS last updated the table statistics record for a table. It does not indicate the time of the last update to the table.
-
xAmzTargetAmazonDmSv20160101ImportCertificate.importCertificateUploads the specified certificate.
-
xAmzTargetAmazonDmSv20160101ListTagsForResource.listTagsForResourceLists all metadata tags attached to an DMS resource, including replication instance, endpoint, subnet group, and migration task. For more information, see data type description.
-
xAmzTargetAmazonDmSv20160101ModifyEndpoint.modifyEndpointModifies the specified endpoint.
For a MySQL source or target endpoint, don't explicitly specify the database using the
DatabaseNamerequest parameter on theModifyEndpointAPI call. SpecifyingDatabaseNamewhen you modify a MySQL endpoint replicates all the task tables to this single database. For MySQL endpoints, you specify the database only when you specify the schema in the table-mapping rules of the DMS task. -
xAmzTargetAmazonDmSv20160101ModifyEventSubscription.modifyEventSubscriptionModifies an existing DMS event notification subscription.
-
xAmzTargetAmazonDmSv20160101ModifyReplicationInstance.modifyReplicationInstanceModifies the replication instance to apply new settings. You can change one or more parameters by specifying these parameters and the new values in the request.
Some settings are applied during the maintenance window.
-
xAmzTargetAmazonDmSv20160101ModifyReplicationSubnetGroup.modifyReplicationSubnetGroupModifies the settings for the specified replication subnet group.
-
xAmzTargetAmazonDmSv20160101ModifyReplicationTask.modifyReplicationTaskModifies the specified replication task.
You can't modify the task endpoints. The task must be stopped before you can modify it.
For more information about DMS tasks, see in the Database Migration Service User Guide.
-
xAmzTargetAmazonDmSv20160101MoveReplicationTask.moveReplicationTaskMoves a replication task from its current replication instance to a different target replication instance using the specified parameters. The target replication instance must be created with the same or later DMS version as the current replication instance.
-
xAmzTargetAmazonDmSv20160101RebootReplicationInstance.rebootReplicationInstanceReboots a replication instance. Rebooting results in a momentary outage, until the replication instance becomes available again.
-
xAmzTargetAmazonDmSv20160101RefreshSchemas.refreshSchemasPopulates the schema for the specified endpoint. This is an asynchronous operation and can take several minutes. You can check the status of this operation by calling the DescribeRefreshSchemasStatus operation.
-
xAmzTargetAmazonDmSv20160101ReloadTables.reloadTablesReloads the target database table with the source data.
You can only use this operation with a task in the
RUNNINGstate, otherwise the service will throw anInvalidResourceStateFaultexception. -
xAmzTargetAmazonDmSv20160101RemoveTagsFromResource.removeTagsFromResourceRemoves metadata tags from an DMS resource, including replication instance, endpoint, subnet group, and migration task. For more information, see data type description.
-
xAmzTargetAmazonDmSv20160101RunFleetAdvisorLsaAnalysis.runFleetAdvisorLsaAnalysisRuns large-scale assessment (LSA) analysis on every Fleet Advisor collector in your account.
-
xAmzTargetAmazonDmSv20160101StartRecommendations.startRecommendationsStarts the analysis of your source database to provide recommendations of target engines.
You can create recommendations for multiple source databases using .
-
xAmzTargetAmazonDmSv20160101StartReplicationTask.startReplicationTaskStarts the replication task.
For more information about DMS tasks, see in the Database Migration Service User Guide.
-
xAmzTargetAmazonDmSv20160101StartReplicationTaskAssessment.startReplicationTaskAssessmentStarts the replication task assessment for unsupported data types in the source database.
You can only use this operation for a task if the following conditions are true:
-
The task must be in the
stoppedstate. -
The task must have successful connections to the source and target.
If either of these conditions are not met, an
InvalidResourceStateFaulterror will result.For information about DMS task assessments, see in the Database Migration Service User Guide.
-
-
xAmzTargetAmazonDmSv20160101StartReplicationTaskAssessmentRun.startReplicationTaskAssessmentRunStarts a new premigration assessment run for one or more individual assessments of a migration task.
The assessments that you can specify depend on the source and target database engine and the migration type defined for the given task. To run this operation, your migration task must already be created. After you run this operation, you can review the status of each individual assessment. You can also run the migration task manually after the assessment run and its individual assessments complete.
-
xAmzTargetAmazonDmSv20160101StopReplicationTask.stopReplicationTaskStops the replication task.
-
xAmzTargetAmazonDmSv20160101TestConnection.testConnectionTests the connection between the replication instance and the endpoint.
-
xAmzTargetAmazonDmSv20160101UpdateSubscriptionsToEventBridge.updateSubscriptionsToEventBridgeMigrates 10 active and enabled Amazon SNS subscriptions at a time and converts them to corresponding Amazon EventBridge rules. By default, this operation migrates subscriptions only when all your replication instance versions are 3.4.6 or higher. If any replication instances are from versions earlier than 3.4.6, the operation raises an error and tells you to upgrade these instances to version 3.4.6 or higher. To enable migration regardless of version, set the
Forceoption to true. However, if you don't upgrade instances earlier than version 3.4.6, some types of events might not be available when you use Amazon EventBridge.To call this operation, make sure that you have certain permissions added to your user account. For more information, see in the Amazon Web Services Database Migration Service User Guide.
-
openapi.previewSpecPreview an OpenAPI document before adding it as a source
-
openapi.addSourceAdd an OpenAPI source and register its operations as tools