© 2016, Amazon Web Services, Inc. or its Affiliates. All rights reserved.

Sergei Sokolenko, Product Lead, AWS RDS and DMS

February 23, 2016

Introduction to AWS Database Migration Service

What to expect from this session

Database migration challengesAWS Database Migration Service 101DMS DemoPricing and resources for customersAWS Schema Conversion Tool 101SCT DemoQ&A

Embracing the cloud, embrace a cloud data strategy

How will my on-premises data migrate to the cloud?

How can I make it transparent to my users?

Afterwards, how will on-premises and cloud data interact?

How can I integrate my data assets within AWS?

Can I get help moving off of commercial databases?

Historically, Migration = Cost, Time

Commercial data migration and replication software

Complex to setup and manage

Legacy schema objects, PL/SQL or T-SQL code

Application downtime

AWS Database Migration Service

Start your first migration in 10 minutes or less

Keep your apps running during the migration

Replicate within, to or from Amazon EC2 or RDS

Move data to the same or different database engine

Learn more at aws.amazon.com/dms

AWSDatabase Migration

Service

10 minutes or less to migration

Demo

CustomerPremises

Application Users

AWS

Internet

VPN

Keep your apps running during the migration

Start a replication instance

Connect to source and target databases

Select tables, schemas, or databases

Let AWS Database Migration Service create tables, load data, and keep them in sync

Switch applications over to the target at your convenience

AWSDatabase Migration

Service

Load is table by table

Creates tables at target databaseSets up metadata required at targetPopulates data from sourceEach process loads one entire tableCan use multiple processesCan be paused

When restarted will continue from where it was stopped Will reload any tables that were currently in progress

Replication instance

Source Target

Change data capture (CDC) and apply

Replication instance

Source Target

update

t1 t2

t1

t2

Transactions

No agent

Uses recovery log

Native change data capture API

Change apply after bulk load

Oracle supplemental loggingMySQL row-level bin logging

SQL Server bulk logged/full recoveryPostgres WAL

Replication instance

Source Target

Multiple targets

Target

Target

Replication instance

Source Target

Multiple sources

Source

Source

You don’t have to take everything

Source

Target

Replication instance instance

Homogenous or heterogeneous

Replication instance

SQL Server MySQL

Replication instance

Oracle Oracle

Replication instance

Oracle Aurora

After migration, use for replication

Replicate data in on-premises databases to AWS

Replicate OLTP data to Amazon Redshift

Integrate tables from third-party software into your reporting or core OLTP systems

AWS Database Migration Service pricing

T2 for developing and periodic data migration tasksC4 for large databases and minimizing time

T2 pricing starts at $0.018 per Hour for T2.microC4 pricing starts at $0.154 per Hour for C4.large

50GB GP2 storage included with T2 instances100GB GP2 storage included with C4 instances Data transfer inbound and within AZ is free

Data transfer across AZs starts at $0.01 per GB

Free during Preview

Resources available to customers

Getting Started Guide. Review technical documentation.Features and Benefits. Highlights DMS features.Pricing. Prices for replication instances, storage, and data transfer.Support. Post your questions to Support Forum.Java SDK. Java-based API for creating and managing data migration tasks.Command Line Interface. Start/Stop replication tasks with simple commands.

Embracing the cloud, embrace a cloud data strategy

How will my on-premises data migrate to the cloud?

How can I make it transparent to my users?

Afterwards, how will on-premises and cloud data interact?

How can I integrate my data assets within AWS?

Can I get help moving off of commercial databases?

AWS Schema Conversion Tool

FeaturesOracle and SQL Server schema conversion to MySQL/Aurora/MariaDB and PostgreSQLDatabase Migration Assessment report for choosing the best target engineCode browser that highlights places where manual edits are required

“AWS Schema Conversion Tool helps automate many database schema and code conversion tasks when migrating from Oracle and SQL Server to open source database engines.”

Get help with converting tables, views, and code

SchemasTablesIndexesViews

PackagesStored ProceduresFunctionsTriggersSequencesUser Defined TypesSynonyms

AWS Schema Conversion Tool

Demo

Pricing and Terms and Conditions

$0for software license

Allowed Use Use SCT to migrate database schemas to Amazon RDS,

Amazon Redshift, or Amazon EC2-based databases To use SCT to migrate schemas to other destinations,

contact for special pricing

Review AWS Service Terms

Pricing Free software license

For active AWS customers with accounts in good standing

Resources available to customers

User Guide. Review technical docs ataws.amazon.com/documentation/SchemaConversionTool/

or click on Download button

Download Area. Get installation files for AWS Schema Conversion Tool Support Forums. Ask questions and review How-To Guideshttps://forums.aws.amazon.com/forum.jspa?forumID=208

Database migration partners

aws.amazon.com/rds/partners/#Database_Migration

Start using the AWS Database Migration Service

Navigate to DMS area of the AWS Management Console

Select “Get Started” Wizard

Create replication instance and task

Download AWS Schema Conversion Tool

Q & A

Thank you!

AWS Summit – Chicago: An exciting, free cloud conference designed to educate and inform new customers about the AWS platform, best practices and new cloud services.

Details• April 18-19, 2016 • Chicago, Illinois• @ McCormick Place

Featuring• New product launches• 50+ sessions, labs, and bootcamps• Executive and partner networking

Register Now• Go to aws.amazon.com/summits• Click on The AWS Summit - Chicago … then register.• Come and see what AWS and the cloud can do for you.

Chicago – April 18-19