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
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 .
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
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 ?
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. ua-cam.com/video/-rZxLCRrgmI/v-deo.html
😂for the interruptions. Thanks for sharing.
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
Yes we can do that
Great demo!
Hi....here you are using credentials directly,is it possible to use keyvalut?
Yes in the devops pipeline specify the key vault option, make sure access policy is granted and you enable "use key vault secrets" option
Really helpful, can you please suggest: does deadlock causes synapse pipeline deployment fail?
yes deadlock could cause deployment failures, ideally you should not have any active transactions while performing deployment.
@@SQL4ALL thank you. It helped
@@SQL4ALL may I know your linked in profile?
@@vijaylakshmi4573 www.linkedin.com/in/azuredataengineer
Hey how do i do this exact thing but with azure repo instrad of git ? I am getting errors
should be working, what error do you get ?
@@SQL4ALL I resolved it , instead of git ui i directly used visual studio thnx for the reply though.
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 .
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
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 ?
Yes create a new server, use parameters to supply the names
@@SQL4ALL Thank You so much
One more question..Can this be implemented using azure runbooks?Bcoz I have imported bacpac files using powershell runbook.
Hi Nice video 😊👌
Will you give training kind of sessions?
Thanks
Yes We could discuss on that
Please drop me an email @ er.lokeshsharma08@gmail.com
do i have to create 50 pipelines for 50 DB's?
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.
ua-cam.com/video/-rZxLCRrgmI/v-deo.html
Hi, How can I make it incremental deployment?
Hi Srikanth, this will be incremental deployment
@@SQL4ALL this dacpac deployment will update current db ? not overwrite
@@skillquench yeah
this video could have been so much better without the ppl there
17:38 that's why I hate to watch any video from India... bugs are always there...