Data and DB Migration

Question 1

What is Storage Gateway, and what are the 3 types of SG?

Answer 1

o Storage Gateway is a virtual appliance, providing hybrid storage service that allows you to migrate data into AWS, extending your on-premises storage capacity using AWS
o 3 types:
 File gateway: stores files as objects in Amazon S3, with a local cache for low-latency access to your most recently used data; files can be accessed directly
 Volume gateway: block storage in Amazon S3 with point-in-time backups as Amazon EBS snapshots (I-SCSI, for NAS – Network Attached Storage: the volume has to be mounted, before the files can be accessed)
 Tape gateway (VTL – Virtual Tape Library): backup your data to Amazon S3 and archive in Glacier using your existing tape-based processes

Question 2

What is Database Migration Service?

Answer 2

o Database Migration Service (AWS DMS) is a service (SaaS) to migrate relational databases, to / from any locations with network connectivity to AWS
o DMS is compatible with a broad range of DB sources, including Oracle, MS SQL, MySQL, MariaDB, PostgreSQL, MongoDB, Aurora and SAP
o Data can be synced to most of the above engines, as well as Redshift, S3 and DynamoDB
o Can use the Schema Conversion Tool (AWS SCT) to transform between different database engines as part of a migration
o Use cases:
 Scaling DB resources up / down without downtime
 Migrating DB to / from on premise / AWS or other cloud platforms
 Moving data between different DB engines, including schema conversions
 Partial data migration
 Migration as a service