Publish only changes from stored procedures and views from one database to another in Azure Repos RRS feed

  • Question

  • I have created a database project in visual studio that includes schemas, tables, stored procedures and tables. I've added them to source control in Azure Repos. I want to publish only the stored procedures and views to another database(they have the same table schemas).

    When the project builds in azure pipeline it would create the build for all the database objects and the release pipeline would publish these changes to the database. Is there any way to exclude the tables and only build and publish stored procedures and views?

    Monday, November 18, 2019 3:58 AM


  • When creating the build in Azure pipeline, can we specify to use SQLPackage.EXE ?

    No modification required in Build. It will build all SQL objects - tables, views, SP etc and create a dacpac including all of them.

    In the release task, you can mention ExcludeObjectTypes=Tables so that it won't deploy them.

    If the response helped, do "Mark as answer" or upvote it
    - Vaibhav

    Monday, November 18, 2019 6:11 AM

All replies