Step 4: Store Database Credentials in Amazon Secrets Manager - 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 4: Store Database Credentials in Amazon Secrets Manager

To connect to your source and target databases with DMS Schema Conversion, store your database credentials in Amazon Secrets Manager. Make sure that you replicate these secrets to your Amazon Region.

To store your source database credentials in Amazon Secrets Manager

  1. Sign in to the Amazon Web Services Management Console and open the Amazon Secrets Manager console at https://console.aws.amazon.com/secretsmanager/.

  2. Choose your Amazon Region.

  3. Choose Store a new secret. The Choose secret type page opens.

  4. For Secret type, choose Credentials for other database.

  5. For User name and Password, enter the credentials of the database user that you created for your source database in Step 2.

  6. For Database, choose SQL Server.

  7. For Server name, Database name, and Port, enter your SQL Server database connection information.

  8. Choose Next. The Configure secret page opens.

  9. For Secret name, enter sc-sql-server-secret.

  10. Choose Next. The Configure rotation page opens.

  11. Choose Next. The Review page opens.

  12. Choose Store.

To store your target database credentials in Amazon Secrets Manager

  1. Sign in to the Amazon Web Services Management Console and open the Amazon Secrets Manager console at https://console.aws.amazon.com/secretsmanager/.

  2. Choose your Amazon Region.

  3. Choose Store a new secret. The Choose secret type page opens.

  4. For Secret type, choose Credentials for Amazon RDS database.

  5. For User name and Password, enter the credentials of the database user that you created for your target database in Step 3.

  6. For Database, choose your Amazon RDS for MySQL DB instance.

  7. Choose Next. The Configure secret page opens.

  8. For Secret name, enter sc-mysql-secret.

  9. Choose Next. The Configure rotation page opens.

  10. Choose Next. The Review page opens.

  11. Choose Store.

Use these secrets when you create your migration project in Step 7.