How to Connect Amazon RDS SQL from Azure Devops for Database Automation

Question

I have a Database which is hosted on Amazon RDS SQL server and was able to connect to it using Management studio, but I was not able to access it using Azure DevOps pipeline. Can anyone help me I want to create a automation build deployment?

Answer 1

You can try running the sqlpackage.exe command in able to deploy the database. Also, you can try running the below command :

"C:\Program Files\Microsoft SQL Server\150\DAC\bin\sqlpackage.exe" /Action:Publish /SourceFile:[path to dacpac] /Profile:[path to publish profile]

This will help you to deploy it.

I hope this will help.

Want to become an Azure expert? join Azure Devops Certification now!!