Reader small image

You're reading from  AWS Certified Database – Specialty (DBS-C01) Certification Guide

Product typeBook
Published inMay 2022
PublisherPackt
ISBN-139781803243108
Edition1st Edition
Right arrow
Author (1)
Kate Gawron
Kate Gawron
author image
Kate Gawron

Kate Gawron is a full-time senior database consultant and part-time future racing driver. She was a competitor in Formula Woman, and she aspires to become a professional Gran Turismo (GT) racing driver. Away from the racetrack, Kate has worked with Oracle databases for 18 years and AWS for five years. She holds four AWS certifications, including the AWS Certified Database – Specialty certification as well as two professional Oracle qualifications. Kate currently works as a senior database architect, where she works with customers to migrate and refactor their databases to work optimally within the AWS cloud.
Read more about Kate Gawron

Right arrow

Cheat sheet

This cheat sheet summarizes the main key points from this chapter:

  • SCT is used to assess and convert a database from one engine into another for a heterogeneous migration.
  • SCT can also be used to assess a homogenous migration in RDS to highlight features that are not supported in your source database.
  • Once you have converted a schema using SCT, you can use DMS to migrate the data into the empty schema and tables.
  • DMS can also be used to create a schema in your target database, but you have no control over the data types that are created in the table.
  • DMS can be used in both full load and CDC mode.
  • To run a DMS task, you need a replication instance, a source endpoint, and a target endpoint.
  • You can run multiple tasks to migrate a single source database to improve performance.
  • For very large databases or complex conversions, you can use AWS Snowball Edge with SCT and DMS to assist with the migration.
lock icon
The rest of the page is locked
Previous PageNext Page
You have been reading a chapter from
AWS Certified Database – Specialty (DBS-C01) Certification Guide
Published in: May 2022Publisher: PacktISBN-13: 9781803243108

Author (1)

author image
Kate Gawron

Kate Gawron is a full-time senior database consultant and part-time future racing driver. She was a competitor in Formula Woman, and she aspires to become a professional Gran Turismo (GT) racing driver. Away from the racetrack, Kate has worked with Oracle databases for 18 years and AWS for five years. She holds four AWS certifications, including the AWS Certified Database – Specialty certification as well as two professional Oracle qualifications. Kate currently works as a senior database architect, where she works with customers to migrate and refactor their databases to work optimally within the AWS cloud.
Read more about Kate Gawron