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!!