Automated Build and Test

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


About way0utwest

Editor, SQLServerCentral
This entry was posted in Presentations and tagged , , . Bookmark the permalink.