Overview of DMS
AWS Database Migration Service (DMS) is a tool for moving your data between databases. DMS can be used to migrate data between databases of the same type or between different database engines. If you use it to migrate between different database engines, it will convert the data for you so that it fits the target. DMS can also create target database tables for you, if they do not already exist, in a similar way to SCT. However, it is much less powerful and only converts the minimal database objects that are required for a successful migration. You would still need to manually create most indexes, views, and database code.
DMS has three main components:
- Endpoints: These allow DMS to connect to databases that are hosted in different VPCs and on-premises.
- Replication Instance: This is an EC2 instance that's used to run the migration.
- Tasks: These are the jobs that control and manage the migration process.
To use DMS, you must provide a source...
