Amazon Database Migration Service vs AWS Schema Conversion Tool
Amazon Database Migration Service
aws.amazon.com
AWS Schema Conversion Tool
docs.aws.amazon.comSide by side
| Figure | Amazon Database Migration Service | AWS Schema Conversion Tool |
|---|---|---|
| Price from | Free | Free |
| Free plan | Yes | Yes |
| Free trial | — | — |
| Open source | — | — |
| Web | Yes | — |
| Windows | — | Yes |
| Linux | — | Yes |
| API | Yes | — |
| Self-hosted | — | Yes |
| Plans published | 4 | 1 |
| Spec score · Cloud Migration Tools | 8.7 (#2) | 8.0 (#7) |
| Spec score · Data Migration Tools | 8.8 (#2) | 8.0 (#6) |
| Integrations | DMS integrates with CloudTrail and CloudWatch Logs, and its API and AWS CLI can automate replication task management and custom monitoring. | AWS SCT integrates with Amazon RDS, Aurora, Redshift, S3, DynamoDB, AWS DMS, AWS Glue, AWS Lambda, and AWS Step Functions for supported conversion and migration workflows. |
| Purpose | AWS DMS migrates relational databases, data warehouses, NoSQL databases, and other data stores to AWS or between cloud and on-premises setups. | AWS SCT converts database schemas from one database engine to another, including relational OLTP, data warehouse, and NoSQL schemas. |
Plans
Amazon Database Migration Service
- AWS Free TierFree
- AWS DMS ServerlessPriced on request
- Database Savings PlansPrice not published
- On-demand instancesPriced on request
In their own words
Amazon Database Migration Service
Amazon Database Migration Service (AWS DMS) is a SaaS service for moving relational databases, data warehouses, NoSQL databases and other data stores to AWS or between cloud and on-premises environments. It handles one-time migrations and continuous replication, with support for both like-for-like and cross-engine moves. AWS says more than 20 databases and data warehouses can serve as source or target endpoints. DMS Schema Conversion assesses schemas and converts many code objects, including views, stored procedures and functions, while identifying work that needs manual conversion. DMS Serverless provisions and scales capacity according to transaction volume, billed hourly. Multi-AZ deployment uses redundant replication instances, and interrupted migrations can resume. API and AWS CLI support automation, while CloudTrail and CloudWatch Logs provide integrations. TLS, VPC deployment, PrivateLink and column masking are available. At least one endpoint must be Amazon RDS or EC2; on-premises-to-on-premises replication is unsupported. The AWS Free Tier offers free with credits.
AWS Schema Conversion Tool
AWS Schema Conversion Tool (AWS SCT) converts database schemas between engines, including relational OLTP, data warehouse, and NoSQL schemas. If it cannot automate a conversion, it gives guidance for creating an equivalent schema in the target database. A project wizard estimates migration complexity for supported destinations and generates a report for comparing target options. For warehouse migrations to Amazon Redshift, it can manage data extraction agents; it can also create, run, and monitor AWS DMS endpoints and tasks. AWS SCT converts SQL embedded in C++, C#, Java, and other application code for users to review, edit, and save. Supported workload conversions include SSIS packages, Teradata workloads, and Apache Oozie workflows to specified AWS services. It is both a standalone, project-based application and a command-line tool. Planned converted schemas stay local until applied to the target. AWS SCT is free and supports 64-bit Microsoft Windows, Fedora Linux, and Ubuntu Linux. It also supports FIPS standards for connections to Amazon S3 or another AWS resource and is compliant with FedRAMP.