DMS SCT Terraform scripts

Question

Hi, can we create an Instance profile, Data providers and Migration project for DMS Schema Conversion using Terraform or Cloud Formation?

Need to do on-premise(Oracle) to AWS RDS Aurora Postgres migration using AWS SCT and DMS.

awstyler · Answer

The AWS provider for Terraform does support 6 of the 7 Database Migration Service (DMS) resource types (list below).

The AWS provider does not support the Schema Conversion Tool (SCT) directly, but it appears that you can use the output from SCT when defining a DMS replication task.

On our AWS Samples GitHub repository we have a AWS DMS Samples that demonstrates how to configure data migration between on premises and Amazon Aurora database in isolated VPCs using DMS.

**AWS Sample Code**
* https://github.com/aws-samples/aws-dms-terraform

**AWS provider documentation** (with examples)
* https://registry.terraform.io/providers/hashicorp/aws/latest/docs/resources/dms_certificate
* https://registry.terraform.io/providers/hashicorp/aws/latest/docs/resources/dms_endpoint
* https://registry.terraform.io/providers/hashicorp/aws/latest/docs/resources/dms_event_subscription
* https://registry.terraform.io/providers/hashicorp/aws/latest/docs/resources/dms_replication_instance
* https://registry.terraform.io/providers/hashicorp/aws/latest/docs/resources/dms_replication_subnet_group
* https://registry.terraform.io/providers/hashicorp/aws/latest/docs/resources/dms_replication_task
* https://registry.terraform.io/providers/hashicorp/aws/latest/docs/resources/dms_s3_endpoint

subhashr · Answer

Please note Terraform or cloudformation is used to create resources in AWS cloud. 
SCT is currently a standalone tool wont support it.
In case you are referring to DMS Schema Conversion in AWS Database Migration Service it is still not supported in cloudformation /terraform.

DMS SCT Terraform scripts

Relevant content