Posts

Showing posts from January, 2020

Database Replication: AWS Database Migration Service

Image
Amazon DMS AWS DMS is an easy to use, cost-effective database replication tool In August 2016, Amazon Web Services released Database Migration Service (DMS). DMS is database replication software focused on making it easier to migrate data from a source database to a target destination like a data warehouse or data lake (within AWS). What is AWS Database Migration Service? DMS supports migrations of data from multiple sources via a few different replication methods. Oracle to Oracle, Oracle, or Microsoft SQL Server to Amazon Aurora and Redshift. DMS also supports MySQL database replication as well as Postgres, and others. In addition to replication data from a database, AWS DMS allows you to continuously replicate your data with high availability and consolidate databases cloud warehouses like Amazon Redshift or object storage Amazon S3. For in-depth details on the supported source and target databases , AWS makes these details available on their site. Types of Database Replica