From the course: AWS Certified Data Engineer Associate (DEA-C01) Cert Prep

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Schema conversion

Schema conversion

From the course: AWS Certified Data Engineer Associate (DEA-C01) Cert Prep

Start my 1-month free trial Buy for my team

Schema conversion

“

- [Professor] When migrating data to and from AWS, it is very common that you'll be changing the underlying database engine. Databases from different vendors use many proprietary features and have significant differences in the data formats, as well as the SQL syntax. As a result, the underlying schema has to be changed for data to be transferred in a heterogeneous migration. Fortunately, DMS offers a schema conversion as a built-in feature. For schema conversions that DMS doesn't support, there is an additional external tool known as the schema conversion tool. In this lesson, we'll cover the capabilities of both of these. For heterogeneous migrations, DMS includes automatic schema conversion that will convert all or most of your database objects. Certain objects will not be able to be converted automatically, and these will be flagged so you can convert them manually. Before it performs a migration, it will generate a report that you can download and review. Also, if you want to…

Contents