AWS Database Blog

Category: AWS Database Migration Service

Database Migration

Introducing Ongoing Replication from Amazon RDS for SQL Server Using AWS Database Migration Service

We are excited to announce a new feature in AWS Database Migration Service (AWS DMS) and Amazon RDS for SQL Server that supports ongoing replication from Amazon RDS for SQL Server sources. AWS DMS helps you migrate databases to AWS quickly and more securely. It also helps you migrate data within AWS. You can migrate […]

Read More

Challenges When Migrating from Oracle to PostgreSQL—and How to Overcome Them

David Rader is the vice president of engineering at OpenSCG. OpenSCG is an AWS Consulting Partner and a leading expert in PostgreSQL, helping customers migrate to, operate, and optimize PostgreSQL and other data platforms on premises and in the cloud. In previous posts, we looked at the overall approach for a successful database migration and […]

Read More

How to Migrate from MySQL to Amazon Aurora using AWS SCT and AWS DMS

MySQL is a great open-source database engine, which a lot of companies use because it’s cost-effective. However, like any other open-source database, it takes a lot of work to get commercial-grade performance out of it. As the size of your database increases, the complexity of scaling and crash recovery in MySQL also increases. Scaling out […]

Read More

Migrate Microsoft Azure SQL Database to Amazon Aurora

Increasingly, customers are looking to move databases from proprietary engines such as Oracle and Microsoft SQL Server to open source engines running on AWS. One of the preferred destinations for this data is Amazon Aurora. In this post, we walk through a migration of a Microsoft Azure SQL database to an Amazon Aurora MySQL cluster […]

Read More

Stream data into an Aurora PostgreSQL Database using AWS DMS and Amazon Kinesis Data Firehose

Using AWS Database Migration Service (AWS DMS), you can migrate data from various sources to most widely used commercial and open-source databases. The service supports homogenous migrations such as Oracle to Oracle. It also supports heterogeneous migrations between different database platforms, such as Oracle to Amazon Aurora or Microsoft SQL Server to MySQL. In addition, […]

Read More

Simplify Data Warehouse Migration to Amazon Redshift Using New AWS Schema Conversion Tool Features

The AWS Schema Conversion Tool (AWS SCT) makes heterogeneous database migrations more predictable by automatically converting the source database schema and most of the database code objects to a format compatible with the target database. To help with migration of on-premises data warehouses to Amazon Redshift, the new version of AWS SCT adds the following important […]

Read More
Database Migration

Debugging Your AWS DMS Migrations: What to Do When Things Go Wrong? (Part 3)

Let’s start with a quick recap from our previous posts, Debugging Your AWS DMS Migrations: What to Do When Things Go Wrong, Part 1 and Part 2. There, we cover the initial steps to take to debug your AWS Database Migration Service (DMS) migrations for environmental issues and to use Amazon CloudWatch metrics to identify […]

Read More

Migrate Delimited Files from Amazon S3 to an Amazon DynamoDB NoSQL Table Using AWS Database Migration Service and AWS CloudFormation

Introduction Recently, AWS Database Migration Services (AWS DMS) added support for using Amazon S3 as a source for your database migration. This new support means that you can now load data in comma-separated value (CSV) format from S3 into any supported target, whether or not the target has native S3 support. In most cases, when […]

Read More

Migration Validation (Part 2) – Introducing Data Validation in AWS Database Migration Service

AWS Database Migration Service (AWS DMS) helps you migrate databases to AWS quickly and securely. You can migrate your data to and from most widely used commercial and open source databases, such as Oracle, Microsoft SQL Server, and PostgreSQL. The service supports homogeneous migrations such as Oracle to Oracle, and also heterogeneous migrations between different […]

Read More