Options
Welcome to SQL CI forum
priyasinha
Redgate › Posts: 548 Silver 1
Welcome to the SQL CI forum
SQL CI is a tool to configure database continuous integration for any CI server.
There are three options to choose from, depending on which CI server you're using:
SQLvCI v2.0 command line: Use this for any CI server. The command line supports four steps that let you build, test, synchronize and publish a Nuget package quickly and easily. The steps are:
Build - creates and validates the SQL creation script used to generate the Nuget package.
Test - generates test data using SQL Data Generator and runs tSQLt tests against the NuGet package. Results are output in JUnit XML format.
Sync - updates the existing database server with the latest version in source control.
Publish - publishes the NuGet package to a NuGet feed.
For more information, see Using the SQL CI command line.
TeamCity plugin: Use this SQL CI plugin to configure database continuous integration for TeamCity. For more information, see Setting up a database build in TeamCity.
TFS MSBuild scripts: Use these scripts to configure database continuous integration for Team Foundation Server (TFS). For more information, see the TFS tutorials on Red Gate's Training Academy.
Find out more or contact us:
Report any issues and raise questions on this forum or email us at support@red-gate.com.
Vote or request for a new feature here.
SQL CI is a tool to configure database continuous integration for any CI server.
There are three options to choose from, depending on which CI server you're using:
SQLvCI v2.0 command line: Use this for any CI server. The command line supports four steps that let you build, test, synchronize and publish a Nuget package quickly and easily. The steps are:
Build - creates and validates the SQL creation script used to generate the Nuget package.
Test - generates test data using SQL Data Generator and runs tSQLt tests against the NuGet package. Results are output in JUnit XML format.
Sync - updates the existing database server with the latest version in source control.
Publish - publishes the NuGet package to a NuGet feed.
For more information, see Using the SQL CI command line.
TeamCity plugin: Use this SQL CI plugin to configure database continuous integration for TeamCity. For more information, see Setting up a database build in TeamCity.
TFS MSBuild scripts: Use these scripts to configure database continuous integration for Team Foundation Server (TFS). For more information, see the TFS tutorials on Red Gate's Training Academy.
Find out more or contact us:
Report any issues and raise questions on this forum or email us at support@red-gate.com.
Vote or request for a new feature here.
Priya Sinha
Project Manager
Red Gate Software
Project Manager
Red Gate Software
