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

1. Sign in to the AWS Management Console and open the AWS DMS console at https://console.aws.amazon.com/dms/v2/.

2. Choose your AWS Region.

3. Choose Migration projects, and then choose Create migration project.

4. For Name, enter a unique name for your migration project. For example, enter sc-project.

5. For Instance profile, choose sc-instance. You created this instance profile in Step 5.

6. For Source, choose Browse, and then choose sc-sql-server. You created this data provider in Step 6.

7. For Secret ID, choose sc-sql-server-secret. You created this secret in Step 4.

8. For IAM role, choose sc-secrets-manager-role. You created this role in Step 1.

9. For Target, choose Browse, and then choose sc-postgresql. You created this data provider in Step 6.

10. For Secret ID, choose sc-postgresql-secret. You created this secret in Step 4.

11. For IAM role, choose sc-secrets-manager-role. You created this role in Step 1.

12. Choose Create migration project.

Use this migration project to convert your SQL Server database schemas to PostgreSQL.