Step 7: Create a Migration Project - Database Migration Guide
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

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 Amazon Web Services Management Console and open the Amazon DMS console at https://console.aws.amazon.com/dms/v2/.

  2. Choose your Amazon 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.