How to Deploy Azure SQL database using dacpac and Azure DevOps?

Hi guys, sharing a demo session on How to use dacpac with Azure SQL and how to build pipelines for that.

Feel free to suggest your learnings in the comment box below

And don't shy away from sending me a Linkedin request

[loveplanes]

😂for the interruptions. Thanks for sharing.

[michaelnoelcortes]

Hello, great session, thank you for sharing. Just one question, can we exclude objects in the deployment? For example out of 5 tables present in the database, i only want to deploy 2

[anvicom]

How do we set the order of SQL scripts that should get deployed? What if I want to have the TableA.sql to get deployed first and then deploy TableB.sql, and then stored procedure A followed by stored procedure B? Where do we configure the script dependencies when dealing with both kinds of deployment, dacpac deployment and SQL File(s) deployment .

[vissum]

Hi....here you are using credentials directly, is it possible to use keyvalut?

[usr]

Hi Nice video 😊👌
Will you give training kind of sessions?

[vijaylakshmi]

Really helpful, can you please suggest: does deadlock causes synapse pipeline deployment fail?

[aadilahmad]

do i have to create 50 pipelines for 50 DB's?

[divyanipardeshi]

Hi SQL4ALL channel, Firstly thank you for such informative session. I was looking for same.
In my use case I want to deploy dacpac into new sql server. Is this possible using the same? Just in Azure devops pipeline if i enter target server ?

[vin.sri.]

Hi, How can I make it incremental deployment?

[paulsanchez]

this video could have been so much better without the ppl there

[dsosys]

17:38 that's why I hate to watch any video from India... bugs are always there...