AWS Database Migration Service - Step-by-Step Migration …

Step-by-Step Walkthroughs

Database Migration Guide

Copyright ? 2023 Amazon Web Services, Inc. and/or its a?liates. All rights reserved.

Database Migration Guide

Step-by-Step Walkthroughs

Database Migration Guide: Step-by-Step Walkthroughs

Copyright ? 2023 Amazon Web Services, Inc. and/or its a?liates. All rights reserved.

Amazon's trademarks and trade dress may not be used in connection with any product or service

that is not Amazon's, in any manner that is likely to cause confusion among customers, or in any

manner that disparages or discredits Amazon. All other trademarks not owned by Amazon are

the property of their respective owners, who may or may not be a?liated with, connected to, or

sponsored by Amazon.

Database Migration Guide

Step-by-Step Walkthroughs

Table of Contents

Database Migration Step-by-Step Walkthroughs ..........................................................................

Oracle Database ............................................................................................................................................

Microsoft SQL Server ...................................................................................................................................

MySQL .............................................................................................................................................................

BigQuery .........................................................................................................................................................

1

1

1

2

2

MariaDB ........................................................................................................................................................... 2

MongoDB ........................................................................................................................................................ 2

PostgreSQL ..................................................................................................................................................... 2

SAP ASE .......................................................................................................................................................... 3

Migrating Databases to Amazon Web Services Managed Databases ............................................ 4

Migrating a MySQL Database to RDS for MySQL or Aurora MySQL .................................................. 4

Full Load ................................................................................................................................................... 5

Performance Comparison .................................................................................................................... 11

AWS DMS Ongoing Replication ......................................................................................................... 11

Resources ................................................................................................................................................ 12

Migrating PostgreSQL Databases to Amazon RDS for PostgreSQL or Amazon Aurora

PostgreSQL .................................................................................................................................................. 12

Full Load ................................................................................................................................................. 14

Performance Comparison .................................................................................................................... 26

Ongoing Replication ............................................................................................................................. 28

Summary ................................................................................................................................................. 28

Resources ................................................................................................................................................ 29

Migrating PostgreSQL databases to Amazon RDS for PostgreSQL with DMS homogeneous

data migrations .......................................................................................................................................... 29

Prerequisites ........................................................................................................................................... 30

Migration Overview .............................................................................................................................. 31

Step-by-Step Migration ....................................................................................................................... 32

Clean Up ................................................................................................................................................. 46

Migrating an Oracle Database to Amazon RDS for Oracle ................................................................ 47

Full Load ................................................................................................................................................. 48

Performance Comparison .................................................................................................................... 60

Ongoing Replication ............................................................................................................................. 61

Summary ................................................................................................................................................. 62

Resources ................................................................................................................................................ 62

iii

Database Migration Guide

Step-by-Step Walkthroughs

Migrating a SQL Server Always On Database to Amazon Web Services ......................................... 63

Prerequisites ........................................................................................................................................... 63

SQL Server Always On Availability Groups ..................................................................................... 64

Migrating an Amazon RDS for MySQL Database to an Amazon DynamoDB target ...................... 67

Why use AWS DMS? ............................................................................................................................. 68

Example data set .................................................................................................................................. 68

Solution overview ................................................................................................................................. 70

Prerequisites ........................................................................................................................................... 71

Step-by-step migration ....................................................................................................................... 72

Migrating an RDS for MySQL database to an S3 data lake ............................................................... 94

Solution Overview ................................................................................................................................ 95

Use case .................................................................................................................................................. 96

Choosing an instance class and storage size .................................................................................. 97

Step-By-Step Migration ....................................................................................................................... 99

Step 0: Con?gure the Source Amazon RDS for MySQL Database ............................................... 99

Step 1: Create a Replication Instance ............................................................................................ 100

Step 2: Create an AWS DMS Source Endpoint ............................................................................. 102

Step 3: Con?gure a Target Amazon S3 Bucket ............................................................................ 104

Step 5: Create an AWS DMS Task ................................................................................................... 110

Step 6: Run and monitor your AWS DMS Task ............................................................................ 114

Step 7: Monitor your migration ...................................................................................................... 114

Limitations ............................................................................................................................................ 116

Conclusion ............................................................................................................................................ 116

Migrating an RDS PostgreSQL database to an S3 data lake ........................................................... 116

Why AWS DMS? .................................................................................................................................. 117

Use case ................................................................................................................................................ 117

Example data set ................................................................................................................................ 118

Solution Overview .............................................................................................................................. 118

Prerequisites ........................................................................................................................................

Step by step migration .....................................................................................................................

Conclusion ............................................................................................................................................

Migrating SQL Server Databases to Amazon RDS for SQL Server .................................................

Full Load ...............................................................................................................................................

Performance Comparison .................................................................................................................

Ongoing Replication ..........................................................................................................................

Summary ..............................................................................................................................................

119

120

136

137

138

147

149

149

iv

Database Migration Guide

Step-by-Step Walkthroughs

Resources .............................................................................................................................................. 150

Migrating from Amazon RDS for Oracle to Amazon RDS for PostgreSQL and Aurora

PostgreSQL ................................................................................................................................................ 150

Can My Oracle Database Migrate? .................................................................................................. 151

Migration Strategies ........................................................................................................................... 153

The 12 Step Migration Process ....................................................................................................... 154

Automation .......................................................................................................................................... 157

Future State Architecture Design ....................................................................................................

Database Schema Conversion ..........................................................................................................

Application Conversion or Remediation ........................................................................................

Script/ETL/Report Conversion .........................................................................................................

157

159

161

162

Integration with Third-Party Applications .................................................................................... 163

Data Migration Mechanism ............................................................................................................... 164

Testing and Bug Fixing ...................................................................................................................... 165

Performance Tuning ........................................................................................................................... 167

Setup, DevOps, Integration, Deployment, and Security ............................................................. 168

Documentation and Knowledge Transfer ...................................................................................... 171

Project Management and Version Control .................................................................................... 171

Post-Production Support .................................................................................................................. 172

Platform Di?erences .......................................................................................................................... 172

Migrating from SAP ASE to Amazon Aurora MySQL ........................................................................ 174

Prerequisites ........................................................................................................................................ 175

Preparation and Assessment ............................................................................................................ 176

Database Migration ............................................................................................................................ 179

Best Practices ...................................................................................................................................... 184

Migrating Databases to the Amazon Web Services Cloud Using the Database Migration

Service .......................................................................................................................................... 186

Migrating an On-Premises Oracle Database to Amazon Aurora MySQL ...................................... 187

Costs ...................................................................................................................................................... 189

Migration High-Level Outline .......................................................................................................... 189

Migration Step-by-Step Guide ......................................................................................................... 193

Working with the Sample Database for Migration ...................................................................... 215

Migrating an Amazon RDS for Oracle Database to Amazon Aurora MySQL ................................ 216

Costs ...................................................................................................................................................... 217

Prerequisites ........................................................................................................................................ 218

Migration Architecture ....................................................................................................................... 219

v

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download