SQL DB Build & Deploy - Bit-bucket & Jenkins

Database - SQL Server
Version control - GIT/Bit bucket
Automation - Jenkins pipeline.

Question/task - I need to build sql database project & deploy thru jenkins pipeline.
Currently we manually build & publish the database but i have scripts which i can use to build(dacpac) & publish to the database but problem scripts only work in VS(visual studio) command prompt. 

Build SQL database project thru Jenkins - Is it possible, if so how ?
Publish SQL database project thru Jenkins - Is it possible, If so how.

Please help me understand the process involved.
Thanks!

Answers

Sign In or Register to comment.