AWS Database Blog

Category: Database

Migrate data from partitioned tables in PostgreSQL using AWS DMS

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

Deploy Amazon RDS Proxy for SQL Server with IAM authentication

Amazon RDS Proxy is a fully managed, highly available database proxy service. You don’t need to provision or manage any additional infrastructure to start using RDS Proxy. In addition to this, Amazon Relational Database Service (Amazon RDS) completely manages maintenance activities for RDS Proxy such as upgrades and patching, which are carried out gradually in […]

New features in AWS DMS 3.5.0

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

How DevOcean built a vulnerability remediation management platform for cloud-native applications using Amazon Neptune

In this post, we discuss how DevOcean uses Amazon Neptune to power its cloud application vulnerability remediation platform. The DevOcean platform provides a unified dashboard to manage security events across all the layers of a customer’s cloud applications. With DevOcean, users can prioritize risk, reduce alert fatigue, and manage remediation faster with appropriate owners within […]

Set up Always Encrypted with Amazon RDS for SQL Server

Customers within a variety of industries (healthcare and life sciences, financial services, and retail, among others) require a stronger security posture. Particularly, if the databases being hosted contain sensitive data such as credit card numbers or national identification numbers (for example, US Social Security numbers), providing a solution that allows you to encrypt this data […]

Power microservices architectures with Amazon MemoryDB for Redis

Applications in the past were monolithic and rigid, and their components were closely coupled with each other, making them difficult to develop, maintain, and adapt to changing business requirements. Today’s businesses need to deliver changes rapidly, frequently and reliably. To overcome these issues, organizations are moving from development of monolithic applications to microservices architectures for […]

Key considerations while migrating bulk operations from Oracle to PostgreSQL

AWS launched Amazon Database Migration Accelerator (Amazon DMA) to accelerate your journey to AWS databases and analytics services and achieve cloud adoption benefits such as cost savings and performance improvements. Amazon DMA has assisted thousands of customers globally to migrate their workloads (database and application) to AWS databases and analytics services. In this post, we […]

Use Amazon DynamoDB global tables in DynamoDB Shell

Global tables build on the global Amazon DynamoDB footprint to provide you with a fully managed, multi-Region, multi-active database that delivers fast, local, read and write performance for massively scaled, global applications. Global tables replicate your DynamoDB tables automatically across your choice of AWS Regions. DynamoDB Shell is an interactive command line interface for DynamoDB. […]

Multitenant best practices for Amazon RDS Custom for Oracle

Amazon Relational Database Service (Amazon RDS) Custom for Oracle is a managed database service for legacy, custom, and packaged applications that require access to the underlying operating system and database environment. Amazon RDS Custom now supports the Oracle Multitenant option on Oracle Database version 19c using Enterprise Edition. With this release, an RDS Custom for […]

Automate creation of multiple AWS DMS endpoints and replication tasks using the AWS CLI

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