Deploy an API web application with Elastic Beanstalk and set-up CI/CD using CodePipline > Configure RDS database connection > Modify Connection String and Inbound Rule
Modify Connection String and Inbound Rule
For our Database instances to be able to work in the AWS cloud environment, we will need to update the Connection String and create a inbound rule to connect to our local MSSQL server.
Update Connection String
- Go to project folder and look for
appsetting.json- In the Connection String, look for DefaultConnection
- Modify the Server, uid, pwd match with the database settings in Elastic Beanstalk.
-cntr.jpg?width=80pc)
- Navigate to AWS RDS Database in AWS Console UI
- Select the database to modify
-modify.jpg?width=60pc)
- Add the following Inbound rule
-inbound-rule.jpg?width=60pc)
- Select the database to modify
Next, we will proceed to migration an test our database to local MSSQL Server.