At this stage, you’ve successfully created a new Microsoft SQL Database on Amazon RDS and migrated your existing Database.
Now, you will change the Database endpoint configuration settings on your Source .NET Application server so that your application starts using the new migrated database.
Connect to your Source .NET Web Server as explained in Connecting your Windows Instances section.
Your .NET application gets the Database connection configurations from “web.config” file located inside the application folder.
Once you open the file, navigate to “<connectionStrings>” section.
Update the parameters with the RDS Target DB values.
|server||Your RDS endpoint URL|
|user id||unicorn (If you set a different user while creating your RDS DB, enter it here instead.)|
|password||awsrocks2021 (If you set a different password while creating your RDS DB, enter it here instead.)|
You should have the similar settings as shown below:
Now, Navigate to Cloudformation and copy NETWebAppURL (as shown below) and paste it into your browser. You should see your Web Application working with your new migrated database.
You have successfully migrated your Database and your Web Application is now using the migrated RDS Database.