Using Azure DevOps for Microsoft SQL Databases with SSDT

[JHatLpool]

A really great demonstration. Clearly, Kamil deserves his 'MVP' status.

[thomasjbyrne]

This was a brilliant explanation! - BUT PLEASE do one for Data deployment

[jayvataliya]

Good work guys, this CI/CD pipeline process for the SQL DB on Azure with Azure DevOps tutorial is great

This tension built with the disappearance of the internet and waiting for its return ... priceless :D

[prashantcloud]

Absolutely Amazing, i was searching for such a simple non complex demo video.👍

[steelgear]

Been looking for a guide like this. Thanks heaps

[gregoryyashgur]

All is great, what is missing is how you configured git in VS to push code to devops

[zuah]

Thanks, Guys for clear and instructive Demo. It covered most of the stuff I need for now as a learner.
Halfway through the CD part, I needed to create a service connection for my Azure subscription and use this service connection name in an Azure Web Site Deployment task in a release pipeline. It would have been nice if you have covered it too.

[kprazzyj]

Hello Kamil.. Great video... Thanks for sharing...

[anilnair]

That was a great explanation also request you to give demo of using azure active directory integrated

[jeroentrimbach]

Thanks guys! Time to play with this :)
Love the energy btw!

[LiMITZERO]

Thanks for the tutorial this exactly my team lucking of.

[debbieedwards]

Thank you so much for this. It would be so useful to see the next step. Im assuming that on the initial creation you then have to run your full data factory pipelines to being all the data in? You you have to do that every time? How do you deal with things like in the next sprint, 3 new columns get added to a table for example. A few days ago I didn't have any understanding of the process at all so to be able to ask more targeted questions now is great

[AnkurJainSolArchitech]

How do you do selective deployment of tables? e.g. How you can update build to ignore 2 tables out of 5?

[michaeledwards]

Once I run the release pipeline, I'm getting "azure sql pipelines A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.
(provider: TCP Provider, error: 0 - No such host is known.)". I Tried allowing all Ips form 0.0.0.0 to 255.255.255.255 but still getting the same error.
Note: I'm able to login into the server using SSMS

[raj]

The first time running build or release pipeline took time by default and later execution will be fast in a self-hosted agent. But windows hosted agent takes time every time due to it download all required component in an agent then build or release process.

[rodrigueschetan]

Hi Kamil,
I have one question regarding dacpac
Can we select only those schema from database, which we want to deploy and ignore others.

[vedanti-vidhan]

Great Video. Can we also have unit testing and the DB back up strategy defined via the pipelines ?

[sid]

nice video, the DACPAC file we create as a artifact of build pipeline can also be created directly from SSMS - Why do we need to create a Solution File then a DACPAC file? thanks

[debbieedwards]

Another Question. I assumed that clicking Rebuild takes a new version of your Azure Database and adds everything into Solution Explorer but When I click Rebuild nothing happens. The only way I can get it to work is each time create a brand new project from the Azure Database but obviously I don't want to do that. Have I missed something important because I just cant get it to work