Category: Database

The AWS Schema Conversion Tool (AWS SCT) makes heterogeneous database migrations predictable by automatically converting the source database schema and a majority of the database code objects, including views, stored procedures, and functions, to a format compatible with the target database. An important part of the AWS SCT is the assessment reports to help you […]

Amazon DocumentDB (with MongoDB compatibility) is a scalable, highly durable, and fully managed database service for operating mission-critical MongoDB workloads. When interfacing with a document database such as Amazon DocumentDB, developers need an environment to test and debug their applications. In this post, we cover how to connect to your Amazon DocumentDB resources from outside […]

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 deploy a read-only DB instance in a secondary AWS Region. With cross-Region read replica, data is asynchronously sent from your primary database instance to a cross-Region read replica in […]

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 […]

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 […]

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 […]

Amazon Relational Database Service (Amazon RDS) Custom for Oracle allows you the flexibility to configure the database authentication method that can help you meet your security needs. A common and traditional method is to use database authentication via user names and passwords, but this method requires more effort from both administrators and users to manage, […]

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, […]

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, […]

AWS Senior Principal Solutions Architect Randy DeFauw has written a four-part series about how to use Amazon DynamoDB global tables as part of your strategy to build resilient, multi-Region applications that have the lowest possible recovery time objective and recovery point objective. This post summarizes each post in the series and provides a single link […]