I was assigned with a task that I need to build, publish and deploy a .dacpac file in order the database to adhere with the changes that take place in the code.

I read several articles but all of them make the assumption of having Visual studio to generate a .sln file and from there they start building up

      - task: VSBuild@1
        displayName: 'Build Solution: bla.sln'
        inputs:
          solution: database/ bla.sln
          platform: 'Any CPU'
          configuration: Release

In my case the bla.sln file is not there and I don’t want to create one (if that’s possible)

Tooling Im using is: pycharm, azure devops pipeline, sql server

Ultimate goal: to have database as code in my repo and a pipeline which when triggered will build, publish and deploy the dacpac to some sql server databases.

Is this even possible?