It’s difficult to fit SQL databases into a continuous delivery platform using standard techniques, but with container’s it easy.
In this session I’ll show you to run SQL Server in containers on Linux and Windows, and how to package your own database schema in a Docker image. That gives you a versioned, portable unit for your database. In non-production environments, you can run any version of the database in a container in seconds, without needing SQL Server installed. In production you can run a container from the tried and tested Docker image to upgrade your existing database – in the datacenter or the cloud. I’ll show you how to automate the whole process in a CI/CD pipeline, which tests and promoted changes to production from every push to source control.