What is AWS Database Migration Service?
AWS Database Migration Service (DMS) migrates databases to AWS quickly and securely with minimal downtime. The source database remains fully operational during migration, allowing applications to continue running with minimal interruption.
DMS supports homogeneous migrations (same database engine) and heterogeneous migrations (different engines like Oracle to Aurora PostgreSQL). For schema conversions in heterogeneous migrations, DMS works together with the AWS Schema Conversion Tool.
Core Features
- Continuous Replication: CDC (Change Data Capture) for ongoing synchronization
- Heterogeneous Migration: Migration between different database engines
- Schema Conversion: Automatic schema conversion with SCT
- Validation: Automatic validation of migrated data
- Serverless: DMS Serverless scales automatically based on workload
Typical Use Cases
Cloud Migration: Migrate on-premises databases to AWS RDS, Aurora, or self-managed databases on EC2. DMS minimizes downtime through continuous replication until cutover.
Database Modernization: Switch from commercial databases (Oracle, SQL Server) to open-source alternatives (PostgreSQL, MySQL) on AWS. The Schema Conversion Tool identifies code adjustments needed.
Ongoing Replication: Use DMS for continuous data replication to data warehouses (Redshift), data lakes (S3), or DR scenarios with geographically separated databases.
Benefits
- Minimal downtime through continuous replication during migration
- Support for all common database engines
- Automatic schema conversion reduces manual effort
- Serverless option eliminates capacity planning
Integration with innFactory
As an AWS Reseller, innFactory supports you with AWS DMS: migration planning, schema conversion, test migration, cutover planning, and validation of migrated data.
Typical Use Cases
Frequently Asked Questions
What is AWS Database Migration Service?
AWS DMS migrates databases to AWS with minimal downtime. The service continuously replicates data while the source database remains active. Supports homogeneous (e.g., Oracle to Oracle) and heterogeneous migrations (e.g., Oracle to PostgreSQL).
Which databases are supported?
DMS supports Oracle, SQL Server, MySQL, MariaDB, PostgreSQL, MongoDB, SAP ASE, IBM Db2, and Amazon databases (Aurora, Redshift, DynamoDB, S3). Schema conversion is done with the AWS Schema Conversion Tool.
How does migration with minimal downtime work?
DMS first performs a full data load. Then changes are continuously replicated (CDC: Change Data Capture). At cutover, you switch to the target database with only seconds to minutes of downtime.
What is the Schema Conversion Tool?
The AWS Schema Conversion Tool (SCT) converts database schemas and code from one engine to another. It analyzes incompatibilities and shows which adjustments require manual intervention.