AWS Database Blog

This post is targeted at technology and IT delivery leaders who are at the crossroads of application and database modernization and are looking for options and advice on how to get this complex database technology transformation right. The technology for storing and managing data – a database – is an essential element of almost every […]

PostgreSQL is an open-source object-relational database system with over 30 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance. AWS offers Amazon Relational Database Service (Amazon RDS) and Amazon Aurora as fully managed relational database services. Amazon RDS for PostgreSQL and Amazon Aurora PostgreSQL-Compatible Edition make it […]

This is the first in a two-part series of posts on how to migrate a multi-TB database to Amazon Relational Database Services (Amazon RDS) Custom for SQL Server. Amazon RDS Custom for SQL Server is a managed database service that automates setup, operation, backups, high availability, and scaling of databases while granting access to the […]

Migrating an Amazon Aurora PostgreSQL-Compatible Edition or Amazon Relational Database Service (Amazon RDS) for PostgreSQL database from one AWS account to another is a common use case in scenarios when you acquire, sell, or merge operations, or if you’re reorganizing your AWS accounts and organizational structure. In this post, we discuss the steps and best […]

In this post, we walk you through a procedure to migrate the PostgreSQL database from Google Cloud Platform (GCP) Cloud SQL to Amazon Relational Database Service (Amazon RDS) for PostgreSQL. To accomplish this task, we use AWS Database Migration Service (AWS DMS), a data migration and replication service. Using AWS DMS you can do the […]

Automation has been both an adjustment and a gift to traditional database administrators (DBAs). Most traditional responsibilities of a DBA involve provisioning, access control, maintenance, monitoring, high availability, and backup/restore. In Part 1 of our series, we talked about how that role evolved to focus less on platform and more on applications. In Part 2, […]

February 9, 2024: Amazon Kinesis Data Firehose has been renamed to Amazon Data Firehose. Read the AWS What’s New post to learn more. In this post, we discuss how to create the data pipelines from Amazon DocumentDB (with MongoDB compatibility) to Amazon Kinesis Data Firehose and publish changes to your destination store. Amazon DocumentDB (with […]

In this post, we test Oracle GoldenGate (OGG) bidirectional replication between two Amazon Relational Database Service (Amazon RDS) for Oracle instances. This can allow mission-critical applications to be highly available across Regions and provide data redundancy and resilience. Active-active replication allows multiple database instances with the same application tables to support read/write operations running independently […]

We are excited to announce a new feature in Amazon DynamoDB that enhances the developer experience by simplifying the handling of ConditionalCheckFailedException. The new ReturnValuesOnConditionCheckFailure parameter for single write operations lets you return a copy of an item as it was during a failed write attempt, reducing the need for a read request if you want to investigate […]

Customers are opting to replicate their critical workloads to Amazon Aurora PostgreSQL-Compatible Edition for ease of use, minimal operational overhead and the ability to break free from commercial licenses. In this post, we explain the high-level steps to migrate data from a highly available on-premises Microsoft SQL Server AlwaysOn secondary read-only database to Amazon Aurora […]