SQL CI

SQL CI 2.1 release notes

2.1.32.336 - June 22nd, 2016 

Feature

  • New version of SQL Compare
    We've updated the version of SQL Compare that powers SQL CI.
    For details of features and fixes, see the SQL Compare 11.6.6 release notes.

Updated add-on

Breaking change to the DLM Automation Teamcity plugin.

From v3 onwards it is now required to install DLM Automation on your build agents to use this plugin. For more information see Why has the TeamCity plugin stopped working?

The following add-ons have all been updated:

  • DLM Automation Teamcity plugin 3.0.0.20

Download DLM Automation Suite add-ons

2.1.31.314 - May 25th, 2016

Feature

  • New version of SQL Compare
    We've updated the version of SQL Compare that powers SQL CI.
    For details of features and fixes, see the SQL Compare 11.6.2 release notes.

Updated add-on

We've renamed two of the add-ons for SQL CI.

The following add-ons have all been updated:

  • DLM Automation Teamcity plugin 2.0.30.649 (formerly SQL CI Teamcity plugin) 
  • DLM Automation TFS Scripts 2.1.31.317 (formerly SQL CI TFS Scripts)

Download DLM Automation Suite add-ons

2.1.30.301 - May 25th, 2016

Feature

  • New version of SQL Compare
    We've updated the version of SQL Compare that powers SQL CI.
    For details of features and fixes, see the SQL Compare 11.6.1 release notes.

Updated add-on

We've renamed four of the add-ons for SQL CI.

The following add-ons have all been updated:

  • DLM Automation Jenkins plugin 1.0.13 (formerly SQL CI Jenkins plugin) 
  • DLM Automation Bamboo plugin 1.0.8 (formerly SQL CI Bamboo plugin)
  • DLM Automation Build VSTS plugin 1.0.16 (formerly SQL CI VSTS plugin)
  • DLM Automation TFS Build plugin 2.0.12.579 (formerly SQL CI TFS Build Plugin)
  • SQL CI TeamCity plugin 2.0.29.638

Download DLM Automation Suite add-ons

2.1.29.298 - May 9th, 2016

Feature

  • New version of SQL Compare
    We've updated the version of SQL Compare that powers SQL CI. This includes support for migrations scripts created with the upcoming SQL Source Control 5.
    For details of features and fixes, see the SQL Compare 11.6.0 release notes.

Updated add-on

We've fixed an issue in the SQL CI Jenkins plugin: running a build on an agent machine will now work if the server machine does not have DLM Automation installed.

  • SQL CI TeamCity plugin 2.0.28.637
  • SQL CI Jenkins plugin 1.0.12

Download DLM Automation Suite add-ons

2.1.28.295 - May 4th, 2016

Feature

  • New version of SQL Compare
    We've updated the version of SQL Compare that powers SQL CI.
    For details of features and fixes, see the SQL Compare 11.5.7 release notes.

Updated add-on

We've fixed an issue in the SQL CI Jenkins plugin: when configuring the Build step, the Send schema information to DLM Dashboard checkbox is no longer selected automatically.

  • SQL CI TeamCity plugin 2.0.27.636
  • SQL CI Jenkins plugin 1.0.11

Download DLM Automation Suite add-ons

2.1.27.283 - April 27th, 2016

Feature

  • New version of SQL Compare
    We've updated the version of SQL Compare that powers SQL CI.e
    For details of features and fixes, see the SQL Compare 11.5.6 release notes.

Updated add-on

  • SQL CI TeamCity plugin 2.0.26.633

Download DLM Automation Suite add-ons

2.1.26.270 - April 20th, 2016

Feature

  • New version of SQL Compare
    We've updated the version of SQL Compare that powers SQL CI.
    For details of features and fixes, see the SQL Compare 11.5.5 release notes.

Updated add-ons

  • SQL CI TeamCity plugin 2.0.25.628

Download DLM Automation Suite add-ons

2.1.25.256 - April 13th, 2016

Feature

  • New version of SQL Compare
    We've updated the version of SQL Compare that powers SQL CI.
    For details of features and fixes, see the SQL Compare 11.5.4 release notes.

Updated add-on

  • SQL CI TeamCity plugin 2.0.23.624

Download DLM Automation Suite add-ons

2.1.24.253 - April 6th, 2016

Feature

  • New version of SQL Compare
    We've updated the version of SQL Compare that powers SQL CI.
    For details of features and fixes, see the SQL Compare 11.5.3 release notes.

Updated add-on

  • SQL CI TeamCity plugin 2.0.23.624

Download DLM Automation Suite add-ons

2.1.23.250 - March 30th, 2016

Feature

  • New version of SQL Compare
    We've updated the version of SQL Compare that powers SQL CI.
    For details of features and fixes, see the SQL Compare 11.5.2 release notes.

Updated add-ons

  • SQL CI TeamCity plugin 2.0.22.623
  • SQL CI VSTS extension 1.0.15

Download DLM Automation Suite add-ons

2.1.22.239 - March 16th, 2016 

Feature

  • New version of SQL Compare
    We've updated the version of SQL Compare that powers SQL CI.
    For details of features and fixes, see the SQL Compare 11.5.1 release notes.

Updated add-on

  • SQL CI TeamCity plugin 2.0.21.622

Download DLM Automation Suite add-ons

2.1.21.236 - March 2nd, 2016

Feature

Updated add-on

  • SQL CI TeamCity plugin 2.0.20.621

Download DLM Automation Suite add-ons

2.1.20.233 - February 24th, 2016

Feature

  • New version of SQL Compare
    We've updated the version of SQL Compare that powers SQL CI.
    For details of features and fixes, see the SQL Compare 11.5.0 release notes.

Updated add-on

  • SQL CI TeamCity plugin 2.0.19.620

Download DLM Automation Suite add-ons

2.1.19.230 - February 17th, 2016

Feature

  • New version of SQL Compare
    We've updated the version of SQL Compare that powers SQL CI. For details of features and fixes, see the SQL Compare 11.4.10 release notes.

Updated add-on

  • SQL CI TeamCity plugin 2.0.18.610

Download DLM Automation Suite add-ons

2.1.18.224 - February 3rd, 2016

Feature

  • New version of SQL Compare
    We've updated the version of SQL Compare that powers SQL CI. For details of features and fixes, see the SQL Compare 11.4.8 release notes.

Updated add-on

  • SQL CI TeamCity plugin 2.0.17.608

Download DLM Automation Suite add-ons

2.1.17.215  - January 20th, 2016

Feature

  • New version of SQL Compare
    We've updated the version of SQL Compare that powers SQL CI. For details of features and fixes, see the SQL Compare 11.4.6 release notes.

Updated add-on

  • SQL CI TeamCity plugin 2.0.17.608

Download DLM Automation Suite add-ons

2.1.16.212 - January 13th, 2016

Feature

  • New version of SQL Compare
    We've updated the version of SQL Compare that powers SQL CI. For details of features and fixes, see the SQL Compare 11.4.5 release notes.

Updated add-on 

  • SQL CI TeamCity plugin 2.0.15.604

Download DLM Automation Suite add-ons

2.1.15.209 - January 6th, 2016

This release contains internal changes only.

Updated add-ons 

  • TeamCity plugin 2.0.14.603
  • TFS Build plugin 2.0.11.478

Download DLM Automation Suite add-ons

2.1.14.206 - December 23rd, 2015

Feature

  • New version of SQL Compare
    We've updated the version of SQL Compare that powers SQL CI. For details of features and fixes, see the SQL Compare 11.4.4 release notes.

Updated add-on 

  • SQL CI TeamCity plugin 2.0.13.602

Download add-ons for the DLM Automation Suite

2.1.12.192 - December 2nd, 2015 

Feature 

  • New version of SQL Compare engine
    We've updated the SQL Compare engine that powers SQL CI. For details of features and fixes, see the SQL Compare 11.4.1 release notes 

Add-on versions 

  • TeamCity plugin 2.0.11.597 
  • TFS Build plugin 2.0.9.415
  • TFS MSBuild scripts 2.1.11.180 

Download add-ons from the DLM Automation Suite add-ons webpage.

2.1.12.189 - November 25th, 2015

Features 

  • New add-ons webpage
    To make the DLM Automation Suite app simpler, we've removed the TeamCity plugin, TFS plugin and TFS MSBuild scripts from the suite. You can now download them from the DLM Automation Suite add-ons webpage, along with add-ons for Jenkins, Bamboo and Visual Studio Team Services.
  • Improved error messages
    We've added more details to some common error messages. For example, when failing to connect to a database, the message now includes the full connection string.
  • New version of SQL Compare engine
    We've updated the SQL Compare engine that powers SQL CI. For details of features and fixes, see the SQL Compare 11.4.0 release notes 

2.1.11.180 - November 19th, 2015

Feature 

  • New version of SQL Compare engine
    We've updated the SQL Compare engine that powers SQL CI. For details of features and fixes, see the SQL Compare 11.3.9 release notes 

Add-on versions 

  • TeamCity plugin 2.0.11.597 
  • TFS Build plugin 2.0.9.415
  • TFS MSBuild scripts 2.1.11.180 

2.1.10.176 - November 11th, 2015

Feature 

  • New version of SQL Compare engine
    We've updated the SQL Compare engine that powers SQL CI. For details of features and fixes, see the SQL Compare 11.3.8 release notes 

Add-on versions 

  • TeamCity plugin 2.0.10.595 
  • TFS Build plugin 2.0.9.415
  • TFS MSBuild scripts 2.1.10.176 

2.1.9.169 - October 28th, 2015

Features 

  • Include database documentation using TFS Build plugin
    In the previous two weeks, we added an option to include SQL Doc database documentation in the NuGet package to the TeamCity plugin, the TFS MSBuild scripts, and the SQL CI build command. This week, we've added the same feature to the TFS Build plugin.

    Note that including documentation increases the build time, particularly for large databases. For more information, see Using the TFS Build plugin. See also Updating the TFS Build plugin.

  • New version of SQL Compare engine
    We've updated the SQL Compare engine that powers SQL CI. For details of features and fixes, see the SQL Compare 11.3.6 release notes 

Add-on versions 

  • TeamCity plugin 2.0.9.590 
  • TFS Build plugin 2.0.8.410
  • TFS MSBuild scripts 2.1.9.169 

2.1.8.167 - October 21st, 2015

Features 

  • Include database documentation using TeamCity plugin and TFS MSBuild scripts
    Last week we added an option to the SQL CI build command to include SQL Doc database documentation in the NuGet package. This week we've made the same option available in the TeamCity plugin and the TFS MSBuild scripts. Note that including documentation increases the build time, particularly for large databases. For more information, see Using the TeamCity plugin or Using the TFS MSBuild scripts.

    We'd love to hear what you think of this feature. Post your feedback on UserVoice

  • New version of SQL Compare engine
    We've updated the SQL Compare engine that powers SQL CI. For details of features and fixes, see the SQL Compare 11.3.5 release notes 

Add-on versions 

  • TeamCity plugin 2.0.8.589 
  • TFS Build plugin 2.0.7.402
  • TFS MSBuild scripts 2.1.8.167 

2.1.7.158 - October 14th, 2015 

Feature 

  • Include database documentation in the NuGet package
    SQL CI can now include SQL Doc database documentation in the NuGet package that it builds. Use the /includeDocs switch in the Build command if you to do this. For more information, see Using the build command. We're considering making further improvements to this feature, which we've noticed currently adds significantly to the build time for large databases. So we'd love to hear what you think of it. Post your feedback on the UserVoice website.

Add-on versions 

  • TeamCity plugin 2.0.7.577 
  • TFS Build plugin 2.0.6.400
  • TFS MSBuild scripts 2.1.7.158 

2.1.6.125 - October 7th, 2015 

Features 

  • Simplified activation
    We've simplified the way you activate SQL CI. You can now use the DLM Automation Suite app to activate SQL CI and all the other tools in the suite. For more information, see Activating.

  • Choose how SQL CI determines compatibility level
    By default SQL CI uses the database's compatibility level to detect supported features. If you prefer, you can now get SQL CI to use server information to determine the compatibility level. To do this in the build, test or sync steps, use the /additionalCompareArgs to exclude the SQL Compare default option UseCompatibilityLevel. See Using the command line.
  • New version of SQL Compare engine
    We've updated the SQL Compare engine that powers SQL CI. For details of features and fixes, see the SQL Compare 11.3.3 release notes 

Fixes

  • SQLCI-270: We've fixed a bug, occurring with some configurations of TeamCity, that was causing the NuGet package to increase in size on every successive build.
  • SQLCI-271: The TFS Build plugin was sometimes failing to generate the automated part of NuGet package version number correctly. We've now fixed this. If you're using this plugin with TFS 2015, you should update to the latest version. See Updating the TFS Build plugin.

Add-on versions 

  • TeamCity plugin 2.0.6.571 
  • TFS Build plugin 2.0.5.398
  • TFS MSBuild scripts 2.1.6.125

2.1.5.85 - September 30th, 2015 

Features

  • Improved performance
    We've improved the startup performance of SQL CI and the SQL Compare engine that powers it, allowing SQL CI to build, test, sync and publish databases more quickly.
  • Improved default behaviour for temporary instance when using Migrations V2 beta
    In previous versions of SQL CI, if you were using Migrations V2 beta and specified a temporary instance in the build or test steps by using the /temporaryDatabaseServer/temporaryDatabaseName/temporaryDatabaseUserName and /temporaryDatabasePassword switches, you also needed to specify these switches to SQL Compare using the /additionalCompareArgs switch. This is no longer necessary. The details of the temporary instance are now automatically passed through to SQL Compare.
  • New version of SQL Compare engine
    We've updated the SQL Compare engine that powers SQL CI. For details of features and fixes, see the SQL Compare 11.3.2 release notes

Add-on versions 

  • TeamCity plugin 2.0.5.562 
  • TFS Build plugin 2.0.4.380
  • TFS MSBuild scripts 2.1.5.85 

2.1.4.61 - September 23rd, 2015 

We've updated the SQL Compare engine that powers SQL CI. For details of features and fixes, see the SQL Compare 11.3.1 release notes

Add-on versions

  • TeamCity plugin 2.0.4.557 
  • TFS Build plugin 2.0.4.380
  • TFS MSBuild scripts 2.1.4.61

Fix 

SQLCI-259:

In earlier versions of SQL CI, the build and test steps failed when handling tables containing FILESTREAM columns. This is still true when you use the default settings. This happens because SQL CI makes a copy of your database on a temporary server. By default, it uses LocalDB for this, which doesn't support FILESTREAM.

However, if you specify an alternative temporary server that supports FILESTREAM instead of using LocalDB, the build and test steps will now work correctly.

For more information, see Build and test steps fail when using a FILESTREAM data column.

2.1.4.52 - September 16th, 2015

We've updated the SQL Compare engine that powers SQL CI. For details of features and fixes, see the SQL Compare 11.3.1 release notes

Add-on versions

  • TeamCity plugin 2.0.4.548
  • TFS Build plugin 2.0.4.380
  • TFS MSBuild scripts 2.1.4.52

2.1.4.42 - September 2nd, 2015

Features 

  • Simplified installation
    SQL CI is now installed as part of the DLM Automation Suite, so you no longer need to run a separate installation process.
  • New environment variable
    To make it easier to maintain references to tools, we've created a new environment variable. To reference the SQL CI executable, use %DLMAS_HOME%\SQLCI\sqlCI.exe
  • Improved integration with DLM Dashboard
    Databases built by SQL CI already show up as recognized schemas in DLM Dashboard. To make this clearer, recognized schemas are now also labelled with the SQL CI icon .
    For more information about how SQL CI works with DLM Dashboard, see SQL CI integration (Dashboard documentation).
  • Updated SQL Compare engine
    We've updated the SQL Compare engine that powers SQL CI. For details of features and fixes, see the SQL Compare 11.2.9 release notes.

Add-on versions

  • TeamCity plugin 2.0.4.543
  • TFS Build plugin 2.0.4.380
  • TFS MSBuild scripts 2.1.4.52

2.1.3.1183 - August 19th, 2015

We've updated the SQL Compare engine that powers SQL CI. For details of features and fixes, see the SQL Compare 11.2.8 release notes

Plugins and script versions

  • TeamCity plugin 2.0.3.535
  • TFS Build plugin 2.0.3.371
  • TFS MSBuild scripts 2.1.3.1183

2.1.2.1168 - July 29th, 2015

Features

  • We've updated the TFS Build plugin. Version 2.0.2.365 supports TFS 2015 and Visual Studio 2015.
    Earlier version of the plugin don't support TFS 2015. If you're using TFS 2015, you'll need to update to the latest version of the plugin and change your configuration. For more details, see Updating the TFS Build plugin.
  • We've also updated the SQL Compare engine that powers SQL CI. For details of features and fixes, see the SQL Compare 11.2.6 release notes.

Plugins and script versions

  • TeamCity plugin 2.0.2.524
  • TFS Build plugin 2.0.2.365 
  • TFS MSBuild scripts 2.1.2.1168

2.1.2.1157 - July 22nd, 2015  

We've made the SQL CI command line easier to use.

Feature 

To help you avoid making errors when using the SQL CI command line, all switch names are now case insensitive.

Plugins and script versions

  • TeamCity plugin (2.0.2.515)
  • TFS Build plugin (2.0.2.349) 
  • TFS MSBuild scripts (2.1.2.1157) 

2.1.1.1130 - July 15th, 2015  

This release contains internal changes that don't affect how SQL CI works, so there aren't any differences between this version and the last. The latest versions are: 

  • SQL CI (2.1.1.1130)
  • TeamCity plugin (2.0.1.509)
  • TFS Build plugin (2.0.2.349) 
  • TFS MSBuild scripts (2.1.1.1130) 

2.1.1.1125 - July 8th, 2015  

This release contains internal changes that don't affect how SQL CI works, so there aren't any differences between this version and the last. The latest versions are: 

  • SQL CI (2.1.1.1125)
  • TeamCity plugin (2.0.1.506)
  • TFS Build plugin (2.0.2.349) 
  • TFS MSBuild scripts (2.1.1.1125) 

2.1.1.1098 - July 1st, 2015  

This release contains a number of small fixes. The latest versions are:

  • SQL CI (2.1.1.1098)
  • TeamCity plugin (2.0.1.503)
  • TFS Build plugin (2.0.2.348) 
  • TFS MSBuild scripts (2.1.1.1098) 

2.1.1.1070 - June 24th, 2015  

This release contains internal changes that don't affect how the product works, so there aren't any differences between this version and the last. The latest versions are:

  • SQL CI (2.1.1.1070)
  • TeamCity plugin (2.0.1.496)
  • TFS Build plugin (2.0.2.348) 
  • TFS MSBuild scripts (2.1.1.1070) 

2.1.1.1068 - June 17th, 2015  

SQL CI can now send information about the packages it builds to DLM Dashboard, so they can be displayed on the dashboard pages as recognized schema. This feature is supported in these new version: 

  • SQL CI (2.1.1.1068)
  • TeamCity plugin (2.0.1.494)
  • TFS Build plugin (2.0.2.346) 
  • TFS MSBuild scripts (2.1.1.1068) 

We've also upgraded the SQL Compare engine that powers SQL CI. For details of features and fixes, see the SQL Compare 11.2 release notes.

Feature 

You can now configure SQL CI with the host and port number of DLM Dashboard, so that when SQL CI builds a package, it sends DLM Dashboard the package name and version number. Once deployed, DLM Dashboard recognizes the schema and automatically displays the package name and version as the schema name, so you don't have to enter it manually. For details of how this works in DLM Dashboard, see SQL CI integration.

  The feature works with DLM Dashboard version 1.4.4.313 and later.

2.1.1.1051 - June 10th, 2015  

We've upgraded the SQL Compare engine that powers SQL CI, so this release contains new versions of: 

  • SQL CI (2.1.1.1051)
  • TeamCity plugin (2.0.1.487)
  • TFS MSBuild scripts (2.1.1.1051) 

For details of features and fixes, see the SQL Compare 11.2 release notes.

2.1.1.1049 - June 3rd, 2015 

We've upgraded the SQL Compare engine that powers SQL CI, so this release contains new versions of:

  • SQL CI (2.1.1.1049)
  • TeamCity plugin (2.0.1.486)
  • TFS Build plugin (2.0.2.344) 
  • TFS MSBuild scripts (2.1.1.1049)

For details of features and fixes, see the SQL Compare 11.2 release notes.

2.1.1.1048 - May 27th, 2015

We've made internal improvements to SQL CI, the TeamCity and TFS Build plugins, and the MSBuild scripts.

These changes don't affect how the tools work, so there aren't any differences between these version and the previous ones.

2.1.1.1028 - May 20th, 2015

We've upgraded the SQL Compare engine that powers SQL CI, so this release contains new versions of SQL CI, the TeamCity plugin (2.0.1.480), the TFS MSBuild scripts (2.1.1.1028) and the TFS Build plugin (2.0.2.340). 

For details of new features and bug fixes, see the SQL Compare 11.2 release notes.

We've also fixed a bug in the TeamCity plugin that caused problems when running the sync step.

Fix

  • SQLCI-253 - TeamCity 9 no longer incorrectly checks out files from VCS when you run the sync build runner

2.1.0.868 - April 22nd, 2015

This release contains improvements to the way our code manages licensing. These are internal changes that don't affect how the product works, so there aren't any differences between this version and the last.

2.1.0.811 - March 31st, 2015

SQL CI (2.1.0.811), the TeamCity plugin (2.0.0.425), TFS Build plugin (2.0.1.317) and MSBuild (2.1.0.811) scripts are now part of the DLM Automation Suite.

Releases

If you have an existing SQL Automation Pack license, a serial number for the DLM Automation Suite has been generated for you. For details of how to upgrade, see Upgrading (DLM Automation Suite documentation).


Didn't find what you were looking for?