SQL Database Project build and publish thru jenkins
I used the DacFx API provided by Microsoft and created an API service that I integrated with jerkins. In the middle of the pipeline, I passed the SqlProject location, my target database information, and dacpac destination. The API uses Publish Method to Deploy and generate the delta and deploy it to the target database.See the link below.https://www.nuget.org/packages/Microsoft.SqlServer.DACFx