1.1.0.1840 - June 23rd, 2014

This release contains a new version of SQL CI (v2.0.0.162). It provides improved support for LocalDB, and support for masked passwords in Smart Assembly and TFS log files.

LocalDB support

If you have LocalDB installed, it'll be used by default during the build and test steps to recreate your database. You don't need to configure the /temporaryDatabaseServer option. If you don't have LocalDB installed, you'll need to enter a temporary server name.

There's also a new /runOnly option in the command line test step and in the Red Gate SQL CI Test runner for TeamCity. It allows you to specify a test class and test name to run, instead of running every test by default.

For more details, see Using the sqlCI.exe command line in SQL Automation Pack v1.1 and later.

Masked passwords

Team Foundation Server passwords were visible in Smart Assembly and TFS log files in the previous SQL Automation Pack release. This issue is fixed in this release, so passwords are now masked.

For details of how to mask passwords in other CI servers, see:

• Bamboo - Mask passwords in script task command line
• Jenkins - EnvInject Plugin

Known issue

Installing the SQL Automation Pack will force your machine to restart automatically by default. To stop this happening, turn off the check box at the bottom of the final installation page.

1.1.0.1765 - June 5th, 2014

This release contains a new version of SQL CI (v2.0.0.106).

Support for TFS MSBuild scripts

The MS Build scripts now support SQL CI v2.0. If you want to set up continuous integration with TFS, you can use the files in the tfs-scripts folder to build, test, synchronize and publish a NuGet package quickly and easily. For more information, see Using the SQL CI TFS MSBuild scripts in SQL Automation Pack.

Known issues

• NAnt build scripts are not supported in this release.
• Installing the SQL Automation Pack will force your machine to restart automatically by default. To stop this happening, turn off the check box at the bottom of the final installation page

1.1.0.7 - May 16th, 2014 

This release contains new versions of SQL CI (v2.0.0.56), the TeamCity plugin (v2.0.0.106), and SQL Doc (v3.0.2.231).

SQL CI

SQLvCI v2.0 supports four steps that let you build, test, synchronize and publish a NuGet package quickly and easily. The steps are:

1. Build - creates and validates the SQL creation script used to generate the NuGet package. 
2. Test - generates test data using SQL Data Generator and runs tSQLt tests against the NuGet package. Results are output in JUnit XML format.
3. Sync - updates the existing database server with the latest version in source control.
4. Publish - publishes the NuGet package to a NuGet feed.

For more information, see Using the sqlCI.exe command line in SQL Automation Pack v1.1 and later.

TeamCity plugin

The latest TeamCity plugin supports three of the new build steps in SQL CI v2.0. On the TeamCity Build Steps page, you can select new runner types:

• Red Gate SQL CI Build
• Red Gate SQL CI Test
• Red Gate SQL CI Sync

The latest plugin is compatible with TeamCity v7 and later. 

SQL Doc

SQL Doc has been updated to v3.0. For more information, see SQL Doc 3.0 release notes.

Fixes

• SQLCI-116 Default output path contains illegal characters

• SQLCI-122 Multi-word additional parameters truncated (/TIL:READ COMMITTED)

• SQLCI-153 CLR feature enabled by default on target server

Known issues

• The Build Scripts automation tool is not supported in this release. For details of how to use this release with your CI system, see Upgrading.
• Installing the SQL Automation Pack will force your machine to restart automatically by default. To stop this happening, turn off the check box at the bottom of the final installation page.