Step 4: Store Database Credentials in AWS Secrets Manager - Database Migration Guide

Step 4: Store Database Credentials in AWS Secrets Manager

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

To store your source database credentials in AWS Secrets Manager

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

  2. Choose your AWS 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 AWS Secrets Manager

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

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