CreateMigrationProject - AWS Database Migration Service

CreateMigrationProject

Creates the migration project using the specified parameters.

You can run this action only after you create an instance profile and data providers using CreateInstanceProfile and CreateDataProvider.

Request Syntax

{ "Description": "string", "InstanceProfileIdentifier": "string", "MigrationProjectName": "string", "SchemaConversionApplicationAttributes": { "S3BucketPath": "string", "S3BucketRoleArn": "string" }, "SourceDataProviderDescriptors": [ { "DataProviderIdentifier": "string", "SecretsManagerAccessRoleArn": "string", "SecretsManagerSecretId": "string" } ], "Tags": [ { "Key": "string", "ResourceArn": "string", "Value": "string" } ], "TargetDataProviderDescriptors": [ { "DataProviderIdentifier": "string", "SecretsManagerAccessRoleArn": "string", "SecretsManagerSecretId": "string" } ], "TransformationRules": "string" }

Request Parameters

For information about the parameters that are common to all actions, see Common Parameters.

The request accepts the following data in JSON format.

Description

A user-friendly description of the migration project.

Type: String

Required: No

InstanceProfileIdentifier

The identifier of the associated instance profile. Identifiers must begin with a letter and must contain only ASCII letters, digits, and hyphens. They can't end with a hyphen, or contain two consecutive hyphens.

Type: String

Required: Yes

MigrationProjectName

A user-friendly name for the migration project.

Type: String

Required: No

SchemaConversionApplicationAttributes

The schema conversion application attributes, including the Amazon S3 bucket name and Amazon S3 role ARN.

Type: SCApplicationAttributes object

Required: No

SourceDataProviderDescriptors

Information about the source data provider, including the name, ARN, and AWS Secrets Manager parameters.

Type: Array of DataProviderDescriptorDefinition objects

Required: Yes

Tags

One or more tags to be assigned to the migration project.

Type: Array of Tag objects

Required: No

TargetDataProviderDescriptors

Information about the target data provider, including the name, ARN, and AWS Secrets Manager parameters.

Type: Array of DataProviderDescriptorDefinition objects

Required: Yes

TransformationRules

The settings in JSON format for migration rules. Migration rules make it possible for you to change the object names according to the rules that you specify. For example, you can change an object name to lowercase or uppercase, add or remove a prefix or suffix, or rename objects.

Type: String

Required: No

Response Syntax

{ "MigrationProject": { "Description": "string", "InstanceProfileArn": "string", "InstanceProfileName": "string", "MigrationProjectArn": "string", "MigrationProjectCreationTime": "string", "MigrationProjectName": "string", "SchemaConversionApplicationAttributes": { "S3BucketPath": "string", "S3BucketRoleArn": "string" }, "SourceDataProviderDescriptors": [ { "DataProviderArn": "string", "DataProviderName": "string", "SecretsManagerAccessRoleArn": "string", "SecretsManagerSecretId": "string" } ], "TargetDataProviderDescriptors": [ { "DataProviderArn": "string", "DataProviderName": "string", "SecretsManagerAccessRoleArn": "string", "SecretsManagerSecretId": "string" } ], "TransformationRules": "string" } }

Response Elements

If the action is successful, the service sends back an HTTP 200 response.

The following data is returned in JSON format by the service.

MigrationProject

The migration project that was created.

Type: MigrationProject object

Errors

For information about the errors that are common to all actions, see Common Errors.

AccessDeniedFault

AWS DMS was denied access to the endpoint. Check that the role is correctly configured.

HTTP Status Code: 400

FailedDependencyFault

A dependency threw an exception.

HTTP Status Code: 400

ResourceAlreadyExistsFault

The resource you are attempting to create already exists.

HTTP Status Code: 400

ResourceNotFoundFault

The resource could not be found.

HTTP Status Code: 400

ResourceQuotaExceededFault

The quota for this resource quota has been exceeded.

HTTP Status Code: 400

S3AccessDeniedFault

Insufficient privileges are preventing access to an Amazon S3 object.

HTTP Status Code: 400

S3ResourceNotFoundFault

A specified Amazon S3 bucket, bucket folder, or other object can't be found.

HTTP Status Code: 400

Examples

Example

This example illustrates one usage of CreateMigrationProject.

Sample Request

{ "MigrationProjectName": "my-migration-project", "SourceDataProviderDescriptors": [ { "DataProviderIdentifier": "arn:aws:dms:us-east-1:012345678901:data-provider:EXAMPLEABCDEFGHIJKLMNOPQRSTUVWXYZ012345", "SecretsManagerSecretId": "arn:aws:secretsmanager:us-east-1:012345678901:secret:myorg/example1/ALL.SOURCE.ORACLE_12-A1B2C3", "SecretsManagerAccessRoleArn": "arn:aws:iam::012345678901:role/myuser-admin-access" } ], "TargetDataProviderDescriptors": [ { "DataProviderIdentifier": "arn:aws:dms:us-east-1:012345678901:data-provider:EXAMPLEABCDEFGHIJKLMNOPQRSTUVWXYZ012345", "SecretsManagerSecretId": "arn:aws:secretsmanager:us-east-1:012345678901:secret:myorg/example1/TARGET.postgresql-A1B2C3", "SecretsManagerAccessRoleArn": "arn:aws:iam::012345678901:role/myuser-admin-access" } ], "InstanceProfileIdentifier": "ip-au-17", "SchemaConversionApplicationAttributes": { "S3BucketPath": "arn:aws:s3:::mylogin-bucket", "S3BucketRoleArn": "arn:aws:iam::012345678901:role/Admin" }, "Tags": [ { "Key": "access", "Value": "authorizedusers" } ], "Description": "description", "TransformationRules": "{\"key0\":\"value0\",\"key1\":\"value1\",\"key2\":\"value2\"}" }

See Also

For more information about using this API in one of the language-specific AWS SDKs, see the following: