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

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

[@loveplanes]

😂for the interruptions. Thanks for sharing.

[@akm_121]

Hey how do i do this exact thing but with azure repo instrad of git ? I am getting errors

[@SQL4ALL]

should be working, what error do you get ?

[@akm_121]

@@SQL4ALL I resolved it , instead of git ui i directly used visual studio thnx for the reply though.

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

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

[@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. kzbin.info/www/bejne/Y6O9qX95h9eao6s

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

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

[@terryliu3635]

Great demo!

[@vin.sri.69]

Hi, How can I make it incremental deployment?

[@SQL4ALL]

Hi Srikanth, this will be incremental deployment

[@skillquench]

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

[@SQL4ALL]

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