Continuous Integration (CI) is a well known process in the software development world, but it’s not often implemented with databases. This is despite the fact that database code could benefit from the practice of checking the changes on a regular basis for potential issues. This talk will show how to implement continuous integration for databases and include more realistic testing of the code for potential issues.

We will set up CI for a SQL Server database project, using the following tools:

  • Team City (CI Server)
  • Subversion (VCS)
  • SQL Automation Pack (database -> CI integration)
  • tSQLt  testing framework
  • SQL Data Generator