How to deploy objects with different schema using DACPAC from sqlpackage.exe RRS feed

  • Question

  • The default schema is set as dbo in the SQL project properties, so all the database objects are now created in the dbo schema. so if I create a different schema but don't want to include that as part of my deployment then how to achieve that using sqlpackage.exe ?


    Tuesday, April 14, 2020 2:21 PM

All replies

  • If you do not want to add in objects in the other schema, why do you include it in the project?

    Please mark as answer, if this was it. Visit my SQL Server Compact blog http://erikej.blogspot.com

    Tuesday, April 14, 2020 5:28 PM
  • apologies for late reply, I dont want to touch schema A while deployment but want to deploy only changes in schema b

    Tuesday, April 21, 2020 10:52 AM