AWS Database Blog
Category: AWS Database Migration Service
How Firmex used AWS SCT and AWS DMS to move 65,000 on-premises Microsoft SQL Server databases to an Amazon Aurora PostgreSQL cluster
This post is co-authored with Eric Boyer and Maria Hristova of Firmex. Firmex is a leading Virtual Data Room provider with more than 20,000 new rooms opened every year. In this post, we discuss how and why Firmex migrated 65,000 databases heterogeneously from their on-premises SQL Server to Amazon Aurora PostgreSQL-Compatible Edition.
New – Accelerate database modernization with generative AI using AWS Database Migration Service Schema Conversion
Today, we’re excited to inform you about a new generative AI feature in DMS SC. You can now use advanced language models to streamline and enhance your migration workflow. In this post, we discuss the key capabilities of DMS SC with generative AI and how to enable it to offer you additional recommendations to reduce manual conversion effort and time.
Migrate time series data to Amazon Timestream for LiveAnalytics using AWS DMS
We are excited to announce Amazon Timestream for LiveAnalytics as a newly supported target endpoint for AWS Database Migration Service (AWS DMS). This addition allows you to move time-series data from an AWS DMS supported source database to Timestream. In this post, we show you how to use Timestream as a target for an example PostgreSQL source endpoint in AWS DMS.
Modernize your legacy databases with AWS data lakes, Part 1: Migrate SQL Server using AWS DMS
This is a three-part series in which we discuss the end-to-end process of building a data lake from a legacy SQL Server database. In this post, we show you how to build data pipelines to replicate data from Microsoft SQL Server to a data lake in Amazon S3 using AWS DMS. You can extend the solution presented in this post to other database engines like PostgreSQL, MySQL, and Oracle.
Migrate or upgrade your like-to-like databases using AWS DMS homogeneous migration
In this post, we highlight common challenges encountered during homogeneous database migrations and how using AWS DMS homogeneous migration can help address them.
How BCM One migrated data from an unencrypted Amazon RDS for PostgreSQL database instance to a new encrypted instance using AWS DMS
This post is co-authored with Kate Fike, Software Engineer at BCM One. BCM One is a leading global provider of NextGen Communications and Managed Services to IT leaders and channel resellers. They have multiple NextGen Communications brands, including Flowroute. Flowroute offers SIP trunking and a business messaging platform for mission-critical voice applications. In this post, […]
Configure cross-account Amazon S3 as a source or target for AWS DMS
In this post, we delve into the intricacies of configuring AWS DMS replication instances to use an S3 bucket in a different account. We also explore the process of establishing a connection between AWS DMS Serverless and S3 buckets across distinct accounts.
Create self-managed replicas for an Amazon RDS for Db2 instance for read scaling and disaster recovery
In this post, we explain how to use RDS Db2 Snapshot and AWS Database Migration Service (AWS DMS) to create cross Region replicas for your RDS for Db2 DB instance. If you want to use this replica for read scaling, there needs to be logic built at the application layer to direct only read traffic to the replica.
Resolving non-responsive connection issue to on-premises Oracle multitenant architecture database having local listeners behind firewall from the cloud
Oracle Multitenant Architecture uses a container-based architecture specifically designed for the cloud. It enables the Oracle database to function as multitenant container database (CDB) where application databases are created as pluggable databases (PDB) inside the container database (CDB). A PDB is a collection of schemas, schema objects and non-schema objects, and self-contained for an application […]
AWS DMS homogenous migration from document-oriented databases to Amazon DocumentDB
In this post, we discuss how to migrate a self-managed document database or Amazon DocumentDB database to Amazon DocumentDB using AWS DMS homogeneous migration.