AWS Database Blog
Category: Amazon RDS
Federated query support between SQL Server and Amazon Aurora PostgreSQL
When you have a business need to integrate the data between Microsoft SQL Server and Amazon Aurora PostgreSQL-Compatible Edition, you can use the open-source TDS_FDW PostgreSQL extension to create federation between these two databases. With TDS_FDW with Aurora PostgreSQL-Compatible, you can modernize and extend the functionality of your existing applications to meet changing business needs. […]
A serverless architecture for analyzing PostgreSQL logs with pgBadger
PostgreSQL is one of the most popular open-source relational database systems. AWS offers services that make PostgreSQL database deployments easy to set up, manage, and scale in a cost-efficient manner. These services are Amazon Relational Database Service (Amazon RDS) for PostgreSQL and Amazon Aurora PostgreSQL-Compatible Edition. Optimizing database performance is an important task for DevOps […]
Use cross-Region read replicas with Amazon Relational Database Service for SQL Server
April 2026: This post was reviewed and updated to reflect single-AZ Read Replica support. August 2023: This post was reviewed and updated to include section for Transparent Data Encryption. Starting today, you can now create cross-Region read replicas with Amazon Relational Database Service (Amazon RDS) for SQL Server. This feature gives you the ability to […]
Create a heterogeneous linked server from Amazon RDS for SQL Server to an Oracle database
Amazon Relational Database Service (Amazon RDS) for SQL Server now supports the Oracle database engine as an external data source to implement heterogeneous linked server configuration and run distributed queries. With this feature, you can now create a linked server configuration between Amazon RDS for SQL Server and an Oracle database instance running in your […]
Migrate Amazon Aurora and Amazon RDS to a new AWS Region
At times you may need to migrate your workloads from one AWS Region to another Region. In this post, we highlight best practices for cross-Region migration of Amazon Relational Database Service (Amazon RDS) and Amazon Aurora . We provide prescriptive guidance on migration of various components related to the RDS databases. We also discuss the […]
Migrate ROW CHANGE TIMESTAMP from IBM Db2 for z/OS to Amazon RDS for PostgreSQL or Amazon Aurora PostgreSQL-Compatible Edition
Customers migrate their mission-critical legacy on-premises databases based on IBM Db2 for z/OS to Amazon Relational Database Service (Amazon RDS) for PostgreSQL or Amazon Aurora PostgreSQL-Compatible Edition for its scalability, performance, agility and availability. In heterogeneous database migrations, not all features in the source database are supported or available in the target database. One such […]
Enable Kerberos authentication with Amazon RDS Custom for Oracle – Part 1
End of support notice: On March 31, 2027, AWS will end support for Amazon RDS Custom for Oracle. Existing customers can continue using the service until March 31, 2027. After March 31, 2027, you will no longer be able to access RDS Custom for Oracle resources including database instances, snapshots, and custom engine versions. We […]
Support JSON data using Amazon RDS for PostgreSQL or Amazon Aurora PostgreSQL and Java Spring Boot on AWS
Many customers choose Amazon Relational Database Service (Amazon RDS) for PostgreSQL or Amazon Aurora PostgreSQL-Compatible Edition to store JSON business objects along with relational transactional data. You can also use the Spring Boot Java framework to implement microservice applications. The Spring Boot framework provides rich features, including auto configuration, dependency injection, metrics measurement, health checks, […]
Migrate on-premises SQL Server to Amazon RDS Custom for SQL Server using native backup and restore and Amazon S3
Amazon Relational Database Services (Amazon RDS) Custom for SQL Server is a managed database service for legacy, custom, and packaged applications that require access to the underlying operating system and database (DB) environment. Amazon RDS Custom is now available for the SQL Server database engine. Amazon RDS Custom for SQL Server automates the setup, operation, […]
Achieve database-level point-in-time recovery on Amazon RDS for SQL Server using access to transaction log backups feature
Amazon Relational Database Service (Amazon RDS) for SQL Server makes it simple to set up and operate SQL Server deployments in the cloud by managing time-consuming database administration tasks, including provisioning, backups, software patching, monitoring, and hardware scaling. Customers running their Microsoft SQL Server workloads on Amazon RDS for SQL Server ask us how they […]









