AWS Database Blog
Category: Migration & Transfer Services
How to encrypt database columns with no impact on your application using AWS DMS and Baffle
AWS offers a wealth of security features to protect its infrastructure and services, such as AWS Identity and Access Management (IAM) and AWS Key Management Service (AWS KMS). AWS Data Migration Service (AWS DMS) provides users a simple automated way of migrating data from their existing databases to HAQM RDS. As part of this, AWS […]
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 HAQM 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 […]
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 […]
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 […]
How to migrate from Oracle to HAQM Aurora MySQL using AWS CloudFormation (Part 1)
Database migrations are challenging, especially for heterogeneous database migrations such as Oracle to HAQM Aurora PostgreSQL, Oracle to HAQM 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 […]
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 […]
The Database Migration Playbook has landed!
We are happy to announce the availability of the first edition in the HAQM 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 […]
A quick introduction to migrating from an Oracle database to an HAQM 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 HAQM 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 […]
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 HAQM RDS (for example, HAQM Aurora MySQL or HAQM Aurora PostgreSQL, among others). You can also convert from a relational […]
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 […]