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
/ sqlbideveloper

[@terryliu3635]

Great demo!

[@loveplanes]

😂for the interruptions. Thanks for sharing.

[@michaelnoelcortes4943]

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

[@sharmafitness2109]

Yes we can do that

[@usr3426]

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

[@SQL4ALL]

Thanks
Yes We could discuss on that
Please drop me an email @ [e-mail]

[@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 .

[@SQL4ALL]

if you are using dacpac, I believe it should take care of the dependencies of pre-defined objects (like sp, table, etc)
For running Adhoc scripts use power shell in your CI/CD pipelines

[@vijaylakshmi4573]

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

[@SQL4ALL]

yes deadlock could cause deployment failures, ideally you should not have any active transactions while performing deployment.

[@vijaylakshmi4573]

@@SQL4ALL thank you. It helped

[@vijaylakshmi4573]

@@SQL4ALL may I know your linked in profile?

[@SQL4ALL]

@@vijaylakshmi4573 www.linkedin.com/in/azuredataengineer

[@divyanipardeshi6403]

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 ?

[@SQL4ALL]

Yes create a new server, use parameters to supply the names

[@divyanipardeshi6403]

@@SQL4ALL Thank You so much

[@divyanipardeshi6403]

One more question..Can this be implemented using azure runbooks?Bcoz I have imported bacpac files using powershell runbook.

[@vissum7165]

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

[@SQL4ALL]

Yes in the devops pipeline specify the key vault option, make sure access policy is granted and you enable "use key vault secrets" option

[@aadilahmad1611]

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

[@crismaxdiaz]

No, it's 1 pipeline per environment per deployment type, typically you want to have a Prod pipeline exclusive for your data related to the solution.
In essence you can add as many databases as you need as part of the solution and in the datpac files. The trick is when you configure the pipeline you need configure the YAML file of the pipeline to add the respective steps for the job to handle the different DBs.
Take a look to this video.
ruclips.net/video/-rZxLCRrgmI/видео.html

[@vin.sri.69]

Hi, How can I make it incremental deployment?

[@SQL4ALL]

Hi Srikanth, this will be incremental deployment

[@user-kn5uk1zx8l]

@@SQL4ALL this dacpac deployment will update current db ? not overwrite

[@SQL4ALL]

@@user-kn5uk1zx8l yeah

[@paulsanchez5030]

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...