AWS Database Blog

Category: Migration

AWS DMS now supports R4 Type Instances and learn to choose the right instance AWS DMS migrations

We are happy to announce support for R4 memory-optimized instances of Amazon EC2 in AWS Database Migration Service (AWS DMS). These instances come with more memory and higher network bandwidth to help support migrations requiring higher throughput and memory-intensive operations. Here you can see the lineup of instances that is supported in DMS. Now that […]

Read More

AWS DMS now supports Binary Reader for Amazon RDS for Oracle and Oracle Standby as a source

We are excited to announce support for Binary Reader for Amazon RDS for Oracle and Oracle Active Data Guard Standby as sources for migration in AWS Database Migration Service (AWS DMS). AWS DMS helps you migrate databases to AWS quickly and relatively securely. It also helps you migrate data within AWS. You can migrate your […]

Read More

AWS Database Migration Service and AWS Schema Conversion Tool now support IBM Db2 LUW as a source

Managing and operating relational databases is a basic piece of maintaining an effective business. Relational databases come in many flavors—commercial (Oracle, Microsoft SQL Server, IBM Db2, and so on) and open source (MySQL, PostgreSQL, and so on). With innovation and improvements in the open-source database world and cloud computing platforms like AWS, many enterprises are […]

Read More

Learn to master MySQL database migrations with Aurora

By Nathaniel Kangpan, SVP Technology & Data Services, Kepler Group I have yet to meet a client in the past 12 months that doesn’t already (a) have a team or two dipping their toes into cloud-based infrastructure, or (b) have the cloud on their roadmap for 2018. Total cost of ownership (TCO) savings for migrating […]

Read More

How to migrate from Oracle to Amazon Aurora MySQL using AWS CloudFormation (Part 1)

Database migrations are challenging, especially for heterogeneous database migrations such as Oracle to Amazon Aurora PostgreSQL, Oracle to Amazon Aurora MySQL, or Microsoft SQL Server to MySQL. The schema structure, data types, and database code of source databases can be quite different from those of the target databases, requiring a schema and code transformation step before the […]

Read More

Introducing schema compare in AWS Schema Conversion Tool

The AWS Schema Conversion Tool (AWS SCT) makes your database migrations more predictable. It does this by automatically converting the source database schema and most of the database code objects to a format compatible with the target database. We’re excited to announce a new feature in AWS SCT to enable schema comparison and synchronization for […]

Read More

The Database Migration Playbook has landed!

We are happy to announce the availability of the first edition in the Amazon Database Migration Playbooks series. We plan for each playbook to be a step-by-step guide that aims to help make heterogeneous database migrations faster and easier and achieve “database freedom.” What the Database Migration Playbooks do The Database Migration Playbooks (a joint […]

Read More

A quick introduction to migrating from an Oracle database to an Amazon Aurora PostgreSQL database

In this post, we build an AWS CloudFormation stack to deploy resources to help demonstrate the process of migrating from an Oracle database to an Amazon Aurora PostgreSQL database. Because this is a heterogeneous migration, we follow a two-phase approach similar to what is detailed in How to Migrate Your Oracle Database to PostgreSQL. The […]

Read More

Schema Conversion Tool blog series: Introducing new features in build 613

The AWS Schema Conversion Tool (AWS SCT) helps convert your existing database schema from one database engine to another. You can convert from a relational OLTP schema or any supported data warehouse OLAP schema to Amazon RDS (for example, Amazon Aurora MySQL or Amazon Aurora PostgreSQL, among others). You can also convert from a relational […]

Read More

How to Migrate from Oracle ASM to AWS using AWS DMS

The Oracle Automatic Storage Management (ASM) database framework provides a volume manager and a file system for Oracle database files. It supports single-instance Oracle Database and Oracle Real Application Clusters (Oracle RAC) configurations. ASM has tools to manage file systems and volumes directly inside a database. These tools enable database administrators (DBAs) to control volumes […]

Read More