AWS Database Blog

Category: Migration

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

Migration Validation (Part 1) – Introducing Migration Assessment in AWS Database Migration Service

We are excited to announce a new feature that provides a pre-migration checklist in AWS Database Migration Service (AWS DMS). AWS DMS does a great job of helping you move your data between multiple supported sources and targets. However, migrations can be difficult, especially when you’re moving from one database engine to another (known as […]

Read More

New AWS DMS and AWS Snowball Integration Enables Mass Database Migrations and Migrations of Large Databases

Before reading this blog post, we recommend that you look at the AWS DMS, AWS SCT and AWS Snowball blogs and get to know these services. More than 40,000 databases have been migrated to AWS using AWS Database Migration Service (AWS DMS), either as a one-time migration or with ongoing replication. AWS Database Migration Service (AWS DMS) and AWS […]

Read More

Amazon Aurora as an Alternative to Oracle RAC

Written by David Yahalom, CTO and co-founder of NAYA Tech—a leading database, big data, and cloud professional and consulting service provider, located in San Jose, CA. In this post, I discuss how Amazon Aurora can serve as a powerful and flexible alternative to Oracle RAC. Both Oracle RAC and Amazon Aurora are designed to provide increased high availability and performance scalability for your databases.

Read More

Crowdsource Database Migration—Let’s Do It Together

We always treat database migration projects as a development exercise. Each project should have proper planning (that is, design), execution, and of course testing. Each step involves developer collaboration. Developers also just like to collaborate on tools, methodologies, and a nice piece of code. We want to facilitate developer collaboration for migration projects, to bring more tools and methods to the community to allow better, smoother, and faster migrations. As part of this effort, we recently launched two GitHub repositories, for AWS DMS samples and AWS DMS tools.

Read More

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

In our previous post, we covered the initial steps to debug AWS Database Migration Service (DMS) migrations for environmental issues. In this post, we continue the debugging process, discussing problems with migration tasks that aren’t in the list preceding and that aren’t due to environmental issues. We review CloudWatch graphs and task and table states to shed light on DMS migrations.

Read More

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

This post walks you through a troubleshooting flow chart to help you understand what could go wrong with migrations using AWS DMS, and it discusses best practices for debugging your AWS DMS migrations. This process involves creating the required AWS DMS components—like the replication instance, source and target endpoints, and the replication task to migrate data from the source endpoint to the target endpoint.

Read More