Step 7: Create a Migration Project - Database Migration Guide

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.