[New Resource]: AWS DMS Migration Project

[oycyc]

Description

Currently, the AWS provider for Terraform related to DMS only has replication related resources.

AWS DMS also has a migration project offering. The primary use for their migration project is to create a project and set up all the connections to source and target database, then use their schema conversion within the migration project. (The replication resources ONLY does the actual data loading, not schema like keys/constraints/triggers)

It would be useful to have this as a resource for the AWS provider for the Database Migration Service with Terraform!

Requested Resource(s) and/or Data Source(s)

• aws_dms_migration_project
• aws_dms_migration_project_instance_profile
• aws_dms_migration_project_data_provider

Potential Terraform Configuration

No response

References

https://docs.aws.amazon.com/dms/latest/userguide/migration-projects-create.html

Their CLI commands for it:

• https://docs.aws.amazon.com/cli/latest/reference/dms/create-migration-project.html
• https://docs.aws.amazon.com/cli/latest/reference/dms/delete-migration-project.html
• https://docs.aws.amazon.com/cli/latest/reference/dms/describe-migration-projects.html
• https://awscli.amazonaws.com/v2/documentation/api/latest/reference/dms/create-migration-project.html

Would you like to implement a fix?

None

[github-actions[bot]]

Community Note

Voting for Prioritization

• Please vote on this issue by adding a 👍 reaction to the original post to help the community and maintainers prioritize this request.
• Please see our prioritization guide for information on how we prioritize.
• Please do not leave "+1" or other comments that do not add relevant new information or questions, they generate extra noise for issue followers and do not help prioritize the request.

Volunteering to Work on This Issue

• If you are interested in working on this issue, please leave a comment.
• If this would be your first contribution, please review the contribution guide.

[oycyc]

This is part of the Go AWS SDK v2 as well:

• https://github.com/aws/aws-sdk-go-v2/blob/release-2023-08-03/service/databasemigrationservice/CHANGELOG.md#v1300-2023-08-03
• https://github.com/aws/aws-sdk-go-v2/blob/main/service/databasemigrationservice/api_op_CreateMigrationProject.go