Category: Migration

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]