😂for the interruptions. Thanks for sharing.

Great demo!

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

5 ай бұрын

Yes we can do that

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

@SQL4ALL

2 жыл бұрын

Thanks Yes We could discuss on that Please drop me an email @ er.lokeshsharma08@gmail.com

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

2 жыл бұрын

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

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

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

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.

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

@crismaxdiaz

5 ай бұрын

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. kzread.info/dash/bejne/X6aO2q58gtXNnaw.html

Hi, How can I make it incremental deployment?

@SQL4ALL

Жыл бұрын

Hi Srikanth, this will be incremental deployment

@user-kn5uk1zx8l

5 ай бұрын

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

@SQL4ALL

5 ай бұрын

@@user-kn5uk1zx8l 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...