PASS logo

November 15-18

Seattle & online

2021 Summit video library

Automate! Use GitHub Actions to Build and Test Database Projects

Liz Baron

Unit Testing is a great way to make hunting down defects and implementing new features faster and easier. But it is an investment, and for that investment to pay off, you need to take the extra step and automatically run all unit tests on newly committed code, before it is moved to downstream environments. This is commonly referred to as Continuous Integration (or CI) and one way to set it up is to use GitHub Actions.

Attend this session by the maintainers of the open-source database unit testing framework tSQLt and learn how to use GitHub Actions to build your database projects, spin up brand new SQL Servers on the fly, deploy those database projects to these new environments, and then run the tests – all automatically for all your commits.

After attending you’ll not only know where Continuous Integration fits into the lifecycle of your projects, you’ll also have the tools needed to set up your own CI environment to support your and your team’s database unit testing efforts.