To connect to your source and target databases in an AWS DMS migration project, 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
-
Sign in to the AWS Management Console and open the AWS Secrets Manager console at https://console.aws.amazon.com/secretsmanager/
. -
Choose your AWS Region.
-
Choose Store a new secret. The Choose secret type page opens.
-
For Secret type, choose Credentials for other database.
-
For User name and Password, enter the credentials of the database user that you created for your source database in Step 2.
-
For Database, choose PostgreSQL.
-
For Server address, Database name, and Port, enter your PostgreSQL database connection information.
-
Choose Next. The Configure secret page opens.
-
For Secret name, enter
dm-postgresql-source. -
Choose Next. The Configure rotation page opens.
-
Choose Next. The Review page opens.
-
Choose Store.
To store your target database credentials in AWS Secrets Manager
-
Sign in to the AWS Management Console and open the AWS Secrets Manager console at https://console.aws.amazon.com/secretsmanager/
. -
Choose your AWS Region.
-
Choose Store a new secret. The Choose secret type page opens.
-
For Secret type, choose Credentials for Amazon RDS database.
-
For User name and Password, enter the credentials of the database user that you created for your target database in Step 3.
-
For Database, choose your Amazon RDS for PostgreSQL DB instance.
-
Choose Next. The Configure secret page opens.
-
For Secret name, enter
dm-postgresql-target. -
Choose Next. The Configure rotation page opens.
-
Choose Next. The Review page opens.
-
Choose Store.
Use these secrets when you create your migration project in Step 7.
