This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(160, 19%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
Hi team,
I want to deploy multiple Azure SQL database objects through dacpac deployment task. The challenge is I have multiple SSDT projects in visual studio project solution, but I want to deploy one SSDT project as per requirement through CICD pipeline in Azure devops. Is there any option to only deploy the required objects and ignore rest?
Could someone please suggest how to create a dacpac file against the required SSDT project and deploy it.
@Bhargava-MSFT , @ShaikMaheer-MSFT
Could you please assist on this?
Hey, just to confirm you have one solution code within which you have multiple different database projects? And your ask is to deploy let's say 1 out of the 5 database projects via dacpac. Is that your ask here?
Hi @Nandan Hegde ,
yes, that was my question I have one solution and which it has different database projects. How to deploy it via dacpac file?
Are you using Azure devops for the deployment?
yes azure devops, and using dacpac deployment task as an agent job
Hi, @Tej Thanks for posting your question in the Microsoft Q&A forum.
I am not totally clear on your question as per what I understand I try to add some info here and if they don't help please add more details and may show how the deployment in CI/CD pipelines now
Regards
Geetha
Hey,
1st create a build pipeline:
that would build the entire solution within the repo.
And then copy the dacpac of all database projects
blog: https://www.nitorinfotech.com/blog/databases-using-azure-devops
Then create seperate release pipelines or tasks mapping to specific dacpacs and destination databases
Also, I have another query, if I include my database objects inside the existing database project in some different folder, How to deploy it through the dacpac file if want to include only the objects inside the folder?
It would really helpful if you can clear my queries.