CODEWITHSUNDEEP
publishazure-pipelinesdacpac
user1094183
user1094183

Reputation: 175

With multiple dacpac, ignore 1 dacpac during deployment

I have a db project in my solution and I create a dacpac for that. I use that dacpac for my VSTS deployment. All is good till then. Now I have to reference another dacpac in my project and make use of it. I add that dacpac to my solution and use it. My DB project works fine. It builds fine too on VSTS But the publish Dacpac fails with error stating that the referenced dacpac could not be found. I want to ignore that dacpac from being compared or making any changes to db since it's just a referenced Dacpac. Let me know

Upvotes: 1

Views: 303

Answers (1)

jagberg
jagberg

Reputation: 53

If you want to reference the other dacpac but not deploy it you can specify the following on deployment to ignore it (using SqlPackage.exe or the Microsoft.SqlServer.Dac.dll library)

/p: IncludeCompositeObjects=false

Upvotes: 1

Related Questions