Step 7: Create a Migration Project
Now you can create a migration project which is the foundation of your work with DMS Schema Conversion. A migration project describes your source and target data providers, your instance profile, and migration rules.
To create a migration project
-
Sign in to the Amazon Web Services Management Console and open the Amazon DMS console at https://console.aws.amazon.com/dms/v2/
. -
Choose your Amazon Region.
-
Choose Migration projects, and then choose Create migration project.
-
For Name, enter a unique name for your migration project. For example, enter
sc-project
. -
For Instance profile, choose
sc-instance
. You created this instance profile in Step 5. -
For Source, choose Browse, and then choose
sc-sql-server
. You created this data provider in Step 6. -
For Secret ID, choose
sc-sql-server-secret
. You created this secret in Step 4. -
For IAM role, choose
sc-secrets-manager-role
. You created this role in Step 1. -
For Target, choose Browse, and then choose
sc-mysql
. You created this data provider in Step 6. -
For Secret ID, choose
sc-mysql-secret
. You created this secret in Step 4. -
For IAM role, choose
sc-secrets-manager-role
. You created this role in Step 1. -
Choose Create migration project.
Use this migration project to convert your SQL Server database schemas to MySQL.