Category: Migration & Transfer Services
In this series of posts (Part 1, Part 2, Part 3 and Part 4) , we compare and contrast the disaster recovery (DR) solutions available for SQL Server on Amazon Elastic Compute Cloud (Amazon EC2) and help you understand the nature of these trade-offs, and the cost and complexity of implementing DR for SQL Server […]Read More
Industry analyst firm Gartner has published a new report, the Magic Quadrant for Cloud Database Management Systems, naming AWS as a Leader and placing AWS highest among the 16 vendors evaluated for “Ability to Execute.” We’re proud to be recognized by Gartner as a Leader for several consecutive years in both the database and analytics […]Read More
AWS Database Migration Service (DMS) announced support of Amazon Managed Streaming for Apache Kafka (Amazon MSK) and self-managed Apache Kafka clusters as target. With AWS DMS you can replicate ongoing changes from any DMS supported sources such as Amazon Aurora (MySQL and PostgreSQL-compatible), Oracle, and SQL Server to Amazon Managed Streaming for Apache Kafka (Amazon MSK) and self-managed Apache Kafka clusters.
In this post, we use an e-commerce use case and set up the entire pipeline with the order data being persisted in an Aurora MySQL database. We use AWS DMS to load and replicate this data to Amazon MSK. We then use the data to generate a live graph on our dashboard application.
Today, we announce the launch of Amazon Database Migration Accelerator (DMA). Amazon DMA brings together AWS Database Migration Service (DMS), AWS Schema Conversion Tool (SCT), and AWS database migration experts to help customers migrate away from traditional commercial databases at fixed prices. At launch, we offer Amazon DMA to customers migrating from Oracle and SQL […]Read More
When migrating a database to a new system using AWS Database Migration Service (DMS), it is prudent to have a fallback strategy if the new system doesn’t work as expected. At a high level, there are four basic strategies for rolling back from a migration: basic fallback, fall forward, dual write, and bidirectional replication. Depending […]Read More
Expanding on the earlier post, Create AWS CloudFormation templates for AWS DMS tasks using Microsoft Excel, this post highlights an enhanced feature of the same tool that can speed database migration. To demonstrate this feature, we present a small command line tool written in Python. The tool takes a CSV file containing the names of […]Read More
AWS now supports new data transformation capabilities in the latest AWS Database Migration Service (AWS DMS) version 3.1.3. You can change schema, table, and column names; specify individual tablespace names for Oracle targets; and update a table’s primary and unique key on any target. DMS version 3.1.3 supports the following new data transformation capabilities: Explicit table […]Read More
September 8, 2021: Amazon Elasticsearch Service has been renamed to Amazon OpenSearch Service. See details. A common pattern for web application architecture includes a database for application data coupled with a search engine for searching that data. Many relational and even nonrelational databases offer rudimentary search capabilities. However, search engines add true, complex, natural-language search […]Read More
AWS Database Migration Service improves migration speeds by adding support for parallel full load and new LOB migration mechanisms
We’re happy to introduce AWS DMS replication engine version 3.1.2. The new version includes a better UX and performance improvements that were requested by many customers. We listened and delivered on our promise to make DMS better. In this blog post, I’ll cover few key new features. For the entire list, see the AWS DMS […]Read More
September 8, 2021: Amazon Elasticsearch Service has been renamed to Amazon OpenSearch Service. See details. We’re excited to announce the addition of a new target in AWS Database Migration Service (AWS DMS)—Amazon Elasticsearch Service. You can now migrate data to Amazon Elasticsearch Service from all AWS DMS–supported sources. With support for this new target, you […]Read More