Category: AWS Database Migration Service

In Part 1 of this series, we discussed how the IDENTITY column is used in different relational database management systems. In this post, we focus on how AWS Database Migration Service (AWS DMS) handles tables with IDENTITY column. For the source database, AWS DMS captures the IDENTITY column as a regular column. For the target […]

Many customers deploy the Oracle Database to an on-premises data centers running general purpose hardware or a highly customized Oracle Exadata hardware. These Oracle database customers are now looking to migrate to Amazon Relational Database Service (Amazon RDS) for Oracle, which is a fully managed commercial database that makes it easy to set up, operate, […]

Customers are migrating to Amazon Redshift to modernize their data warehouse solution and help save on their licensing, support, operations, and maintenance costs. To migrate data from an on-premises data warehouse to Amazon Redshift, you can use services such as AWS Database Migration Service (AWS DMS), AWS Schema Conversion Tool (AWS SCT), Amazon Simple Storage […]

Migrating workloads from PostgreSQL to a data warehouse like Amazon Redshift can pose challenges during the change data capture (CDC) phase when dealing with partitioned tables. In this post, we illustrate how we can migrate data from PostgreSQL partitioned tables to a single table on the target database using AWS Database Migration Service (AWS DMS). […]

We are excited to announce the availability of AWS Database Migration Service (AWS DMS) replication engine version 3.5.0. This version provides improvements to task logging, new data type support, and AWS service integrations that were requested by many of our customers. For the entire list of improvements, refer to AWS Database Migration Service 3.5.0 Beta […]

July 2023: This post was reviewed for accuracy. AWS Database Migration Service (AWS DMS) is a managed migration and replication service that helps move your database and analytics workloads to AWS quickly, securely, and with minimal downtime and zero data loss. AWS DMS can migrate your data from AWS DMS supported sources to AWS DMS […]

AWS Database Migration Service (AWS DMS) is used for migrating databases to AWS, but you can also use it for replicating data with low latency from any supported source to any supported target. When working with Oracle database, AWS DMS stops replicating data changes due to reset logs when the standby database is transitioned to […]

Database migration is a complex process that usually involves capacity planning, data migration and cutover strategies, hardware and software procurement, and a lengthy debugging and testing schedule. The common challenge in migrating from a relational database to a non-relational database is selecting the appropriate modeling technique and migration technologies. This is the second part of […]

This is a guest post by Niv Gelbermann Shkolnik , Software Engineer at Skai co-authored with Eran Balan, Senior Solutions Architect at AWS. Skai is the leading omnichannel platform that helps performance marketers plan, activate, and measure programs across digital media for informed decisions, high efficiency and optimal return. In this post, we discuss how […]

Migrating certain workloads (application and database) to new cloud platforms can be technically challenging. AWS launched Amazon Database Migration Accelerator (Amazon DMA) to accelerate and simplify your journey to AWS databases and analytics services. Amazon DMA has assisted thousands of customers globally to migrate their workloads. In this post, we share Amazon DMA’s approach and […]