Wednesday, 28 September 2016

AWS Database migraton service..it gets more fantastic with AWS

AWS Database Migration Service is a web service you can use for migrating data from database. Various scenarios that DMS supports :--
Database that is on-premises, to an Amazon Relational Database Service (Amazon RDS) DB instance
 Database that is on-premises, to a database on an Amazon Elastic Compute Cloud (Amazon EC2)
Migrate a database from an AWS service to an on-premises database.
Supported DB types and versions
Oracle versions 10g, 11g, 12c, for the Enterprise, Standard, Standard One, and Standard Two edition
Microsoft SQL Server versions 2005, 2008, 2008R2, 2012, 2014, and 2016 for the Enterprise, Standard, Workgroup, and Developer editions.
MySQL versions 5.5, 5.6, and 5.7
PostgreSQL versions 9.3 and later
Types of DB migrations
Homogenous
The DB migrations between the same engine type versions.
Heterogeneous
The DB migrations between the different engine type versions.
                      DMS Components










AWS DMS uses a replication server that connects to the source database, reads the source data, formats the data for consumption by the target database, and loads the data into the target database
At Source DB endpoint DMS collates the data and collects necessary information to convert them in a meaningful way.

At Target DB endpoint DMS migrate all objects to the specified database and schema or create each database and schema for you as it finds the schema on the source

Typically DMS can have 3 types of tasks

Migrate existing data (Full Load)
Take a outage and migrate the complete data from source to target.

Migrate existing data and replicate ongoing changes
This option performs a full data load while capturing changes on the source. Once the
full load is complete, captured changes are applied to the target

Replicate data changes only
In some situations AWS DMS can be used only to replicate changes starting when you
start your bulk load( using any other tool) and keep your source and target databases in
sync


!!Keep experimenting!!