If you are concerned about database performance, optimizing cost for your database, answer to all will be migrating and modernizing your databases on cloud. In this blog, we are going to focus on DB migration options using AWS native tools
Database migration to cloud can be of two kinds – Heterogeneous and homogenous
In heterogeneous migration, a schema conversion tool is applied and in homogeneous migration, a database migration service is used.
AWS Database Migration Service
AWS Native DMS helps migrate databases to AWS quickly and securely. In this case ,
Source database remains operational during the migration Downtime is minimized and impacts least to applications that rely on the database Can be used to migrate your data to & from the most commonly used DBs - commercial and open-source databases.
AWS Database Migration Service supports both cases mentioned that are :-
Homogeneous migrations such as Oracle-to-Oracle Heterogeneous migrations between different database platforms, Example - Oracle or MS SQL Servers to Amazon Aurora
Key Benefits that this tool brings are
Simple to use with Minimal downtime Low cost and supports wide varies of database Continuous replication & Reliability Let us discuss few Use cases
Homogeneous Database Migrations
As the name suggest in homogeneous database migrations, the source and target database engines are the same or are compatible, this means database codes , type and schema structures are compatible and this process becomes easy one-step process . AWS DMS service takes care of the rest. We can name few examples like
Oracle to Amazon RDS for Oracle MySQL to Amazon Aurora MySQL to Amazon RDS for MySQL Microsoft SQL Server to Amazon RDS for SQL Server
Multiple database can be located in your own premises or other sources with a target of a database in Amazon EC2 or Amazon RDS.
Heterogeneous Database Migrations
In such cases database migrations, process is not straightforward, and, requires schema and code transformation before data migration can start. This is because database engines are different and this makes it a two-step process as compared to a single step in homogenous DB migration.
Step 1 - Use the AWS Schema Conversion Tool to change & convert the source schema and code to match that of the target database
Step 2 – Use AWS DMS to migrate data from the source database to the target identified. All required data types will be automatically converted during the migration
Source database can come from multiple location and targets can be identified as Amazon EC2 or Amazon RDS
Examples of Heterogeneous database migrations are
Oracle to Amazon Aurora Oracle to PostgreSQL Microsoft SQL Server to MySQL
Few more use cases for AWS Database Migration Service are for
1. Continuous Replication & DR
Multiple use-case of continuous data replication using Database Migration Services can be
DR synchronization Geo DB replication /distribution Dev/Test synchronization
Database Migration Service from AWS supports both homogenous and heterogeneous data replication for all supported database engines.
2. Development and Test of production systems
AWS Database Migration Service can be effectively used to test real production like uses-cases and then copy updates back to on-prem production systems
3. Database Consolidation
One of the powerful use-case for DMS services is to consolidate multiple source databases into a single target database and yes this works both for heterogeneous and homogenous type of migrations .Sources of such databases can come from different locations and Database Migration Service can be used to consolidate it into AWS EC2 or AWS RDS
Coforge is helping several customers migrate and modernize database via AWS native services to enable and accelerate cloud adoption