DLM Automation Suite

DLM Automation Suite 1.3 release notes

Page last updated 30 March 2016

1.3.21.527 - March 16th, 2016 

SQL CI  2.1.22.239 

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.

SQL Release 1.3.11.1306

Feature

  • New version of SQL Compare
    We've updated the version of SQL Compare that powers SQL Release.
    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

Command line tools for SQL Server 

1.3.20.463 - March 2nd, 2016 

SQL CI  2.1.21.236 

Feature

SQL Release 1.3.10.1300

Feature

DLM Dashboard 1.6.8

Feature

  • We've updated the version of SQL Compare that DLM Dashboard uses. This has solved a number of minor issues.

For full details of features and fixes for DLM Dashboard, see the DLM Dashboard release notes.

Updated add-on

  • SQL CI TeamCity plugin 2.0.20.621

Download DLM Automation Suite add-ons

Command line tools for SQL Server 

1.3.19.460 - February 24th, 2016 

SQL CI  2.1.20.233 

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.

SQL Release 1.3.9.1275

Feature

  • New version of SQL Compare
    We've updated the version of SQL Compare that powers SQL Release.
    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

Command line tools for SQL Server 

1.3.18.455 - February 17th, 2016 

SQL CI  2.1.19.230 

Feature

SQL Release 1.3.8.1251

Features

Known issue

  • SQLREL-114:
    There's an issue with the New-DlmDatabaseDocumentation cmdlet when you use it to create documentation for a scripts folder and specify a temporary database. The cmdlet will fail if you don't enter the case of the temporary database correctly, even if it's on a case-insensitive server.

Updated add-on

  • SQL CI TeamCity plugin 2.0.18.610

Download DLM Automation Suite add-ons

Command line tools for SQL Server 

1.3.17.445 - February 3rd, 2016 

SQL CI  2.1.18.224 

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.

SQL Release 1.3.7.1032

Features

  • Sync-DlmDatabaseSchema cmdlet
    The latest cmdlet we've added to SQL Release can update a target database to match a source schema. The source can be a script folder, a NuGet package or the output of the New-DlmDatabaseConnection cmdlet. For more information, see Sync-DlmDatabaseSchema.
  • New version of SQL Compare
    We've updated the version of SQL Compare that powers SQL Release. 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

Command line tools for SQL Server 

1.3.16.438 - January 27th, 2016 

SQL Release 1.3.6.890

Feature

DLM Dashboard 1.6.7

This release of DLM Dashboard contains internal changes only.

Command line tools for SQL Server 

1.3.15.421 - January 20th, 2016 

SQL CI  2.1.17.215 

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.

SQL Release 1.3.5.743

Features

  • Export-DlmDatabaseTestResults cmdlet
    Last week we added a new SQL Release cmdlet, Invoke-DlmDatabaseTests, for running tSQLt tests on a database schema. Now you can export the results to disk using the Export-DlmDatabaseTestResults cmdlet.
    For more information, see Invoke-DlmDatabaseTests and Export-DlmDatabaseTestResults.
  • New version of SQL Compare
    We've updated the version of SQL Compare that powers SQL Release. For details of features and fixes, see the SQL Compare 11.4.6 release notes.

Updated add-on 

  • SQL CI TeamCity plugin 2.0.15.605

Download DLM Automation Suite add-ons

Command line tools for SQL Server 

1.3.14.418 - January 13th, 2016 

SQL CI  2.1.16.212 

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.

SQL Release 1.3.4.653

Features

  • Invoke-DlmDatabaseTests cmdlet
    We've added a new cmdlet to SQL Release that allows you to run tSQLt tests on a database schema.
    For more information, see Invoke-DlmDatabaseTests.
  • New version of SQL Compare
    We've updated the version of SQL Compare that powers SQL Release. 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

Command line tools for SQL Server 

1.3.13.407 - January 6th, 2016 

SQL CI  2.1.15.209 

This release of SQL CI contains internal changes only.

SQL Release 1.3.3.582

Feature

  • Invoke-DlmDatabaseSchemaValidation cmdlet
    We've added a new cmdlet to SQL Release that allows you to validate a database scripts folder. For more information, see Invoke-DlmDatabaseSchemaValidation.

DLM Dashboard 1.6.6

This release of DLM Dashboard contains internal changes only.

Updated add-ons 

  • SQL CI TeamCity plugin 2.0.14.603
  • SQL CI TFS Build plugin 2.0.11.478

Download DLM Automation Suite add-ons

Command line tools for SQL Server 

1.3.12.399 - December 23rd, 2015 

SQL CI  2.1.14.206 

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.

SQL Release 1.3.2.474

Feature

  • New version of SQL Compare
    We've updated the version of SQL Compare that powers SQL Release. 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 DLM Automation Suite add-ons

Command line tools for SQL Server 

1.3.11.393 - December 9th, 2015 

SQL Release 1.3.1.323

This release contains internal changes only.

DLM Dashboard 1.6.4

Feature 

  • View database documentation
    If you're integrating DLM Dashboard with SQL CI, you can now view SQL Doc database documentation in DLM Dashboard.
    For full details of features and fixes for DLM Dashboard, see DLM Dashboard release notes. 

Command line tools for SQL Server 

1.3.10.380 - December 2nd, 2015 

This release contains new versions of:

SQL CI  2.1.12.192 

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.601 
  • 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.

SQL Release 1.3.0.270

Features

  • Renamed cmdlets
    To make the SQL Release cmdlet names easier to find, we've added the prefix, Dlm. For more information, see Cmdlet reference. The old names for the cmdlets are still valid.
  • New version of SQL Compare engine
    We've updated the SQL Compare engine that powers SQL Release. For details of features and fixes, see the SQL Compare 11.4.1 release notes. 

Command line tools for SQL Server 

1.3.9.372 - November 25th, 2015 

This release contains new versions of:

SQL CI  2.1.12.189 

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.  

SQL Release 1.2.12.234

Feature

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

DLM Dashboard 

For full details of features and fixes for DLM Dashboard, see DLM Dashboard release notes. 

Command line tools for SQL Server 

1.3.8.354 - November 19th, 2015 

This release contains new versions of:

SQL CI  2.1.11.180 

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 

SQL Release 1.2.11.209

Features

  • Additional database connection string properties
    When using a database connection string in place of the New-DatabaseConnection cmdlet, you can now specify a number of additional properties. For more information see New-DatabaseConnection Cmdlet reference.
  • New version of SQL Compare engine
    We've updated the SQL Compare engine that powers SQL Release. For details of features and fixes, see the SQL Compare 11.3.9 release notes. 

DLM Dashboard 

For full details of features and fixes for DLM Dashboard, see DLM Dashboard release notes. 

Download DLM Dashboard

Command line tools for SQL Server 

1.3.7.332 - November 11th, 2015 

This release contains new versions of:

SQL CI  2.1.10.176 

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 

SQL Release 1.2.10.194

Feature

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

DLM Dashboard 

Feature 

  • We've made some minor improvements to the appearance of the DLM Dashboard user interface.

For full details of features and fixes for DLM Dashboard, see DLM Dashboard release notes. 

Download DLM Dashboard

Command line tools for SQL Server 

1.3.6.319 - October 28th, 2015 

This release contains new versions of:

SQL CI  2.1.9.169 

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 

SQL Release 1.2.9.123

Feature

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

DLM Dashboard 

Feature 

  • DLM Dashboard administrators can now manually give permissions to users and groups.

For full details of features and fixes for DLM Dashboard, see DLM Dashboard release notes. 

Download DLM Dashboard

Command line tools for SQL Server 

 

1.3.5.315 - October 21st, 2015 

This release contains new versions of:

SQL CI  2.1.8.167 

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 

SQL Release 1.2.8.111

Feature

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

DLM Dashboard

For details of features and fixes for DLM Dashboard, see DLM Dashboard release notes. 

Download DLM Dashboard

Command line tools for SQL Server 

 

1.3.4.300 - October 14th, 2015 

This release contains new versions of:

SQL CI  2.1.7.158 

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 want 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 UserVoice. 

Add-on versions 

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

DLM Dashboard

Feature 

  • Manage users and permissions
    You can now restrict DLM Dashboard access to specific users, and set permission levels to control what each user is able to do.

For full details of features and fixes for DLM Dashboard, see DLM Dashboard release notes. 

Download DLM Dashboard

Command line tools for SQL Server 

 

1.3.3.286 - October 7th, 2015 

Features

SQL CI  2.1.6.125 

Features 

  • 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 

SQL Release 1.2.7.104

Features

  • Choose how SQL Release determines compatibility level
    By default SQL Release uses the database's compatibility level to detect supported features. If you prefer, you can now get SQL Release to use server information to determine the compatibility level. To do this, use the -SQLCompareOptions parameter in the New-DatabaseRelease cmdlet to exclude the SQL Compare default option UseCompatibilityLevel. See Using SQL Compare options in SQL Release.
  • New version of SQL Compare engine
    We've updated the SQL Compare engine that powers SQL Release. For details of features and fixes, see the SQL Compare 11.3.3 release notes. 

DLM Dashboard

For details of features and fixes for DLM Dashboard, see DLM Dashboard release notes. 

Download DLM Dashboard

Command line tools for SQL Server 

 

1.3.2.233 - September 30th, 2015

This release contains new versions of: 

SQL CI  2.1.5.85 

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 

SQL Release 1.2.6.97

Features

  • Improved performance
    We've improved the startup performance of the SQL Compare engine that powers SQL Release, allowing it to deploy databases more quickly.
  • New version of SQL Compare engine
    We've updated the SQL Compare engine that powers SQL Release. For details of features and fixes, see the SQL Compare 11.3.2 release notes. 

DLM Dashboard

Features 

  • Improved live refresh to support more users
  • Manual pipelines
    You can now create new pipelines for your databases, and move databases between pipelines manually.

For full details of features and fixes for DLM Dashboard, see DLM Dashboard release notes. 

Download DLM Dashboard

Command line tools for SQL Server 

 


1.3.2.202 - September 23rd, 2015

This release contains new versions of: 

SQL CI  2.1.4.61 

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.

SQL Release 1.2.6.91

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

DLM Dashboard

Feature 

  • Manual pipelines: You can now create new pipelines for your databases, and move databases between pipelines.

For full details of features and fixes for DLM Dashboard, see DLM Dashboard release notes. 

Download DLM Dashboard

Command line tools for SQL Server 


1.3.1.196 - September 17th, 2015

This release contains a new version of SQL Release.

SQL Release 1.2.5.89 

Fix

  • SQLREL-94: We've fixed a bug that was stopping the Changes.html report from opening in Chrome.


1.3.0.194 - September 16th, 2015

This release contains new versions of:

Fix

We've fixed a bug in the DLM Automation Suite installer that was causing upgrades from the previous version of the suite or the SQL Automation Pack to fail.

SQL CI  2.1.4.52 

We've updated the SQL Compare engine that powers SQL CI. For details of features and fixes, see the SQL Compare 11.3.0 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 

SQL Release 1.2.4.81

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

Fix

SQLREL-92:

We've fixed the parsing error where SQL Release was failing to pick up static data in script folders when there was an opening parenthesis directly after the CREATE TABLE statement and on the same line.

However, if you edit the script, you still need to make sure the column definitions for the table are on subsequent lines.

Known issue

SQLREL-94:

The Changes.html report that's created as part of the database deployment resources currently won't open in Chrome. Open it in Internet Explorer or Firefox instead.

DLM Dashboard

Feature

  • We've updated DLM Dashboard's user interface to the new Redgate style.

For full details of features and fixes for DLM Dashboard, see DLM Dashboard release notes. 

Download DLM Dashboard

Command line tools for SQL Server

 

1.3.0.159 - September 2nd, 2015

Features

Known issue

SQLREL-92:
If you run a silent install of the DLM Automation Suite, changes to the SENDFUR and SENDERRORS parameters won't be recognized. Feature usage and error reports will be sent to Redgate by default.

To work around this, you can change the default settings after installation:

  1. Open Registry Editor (regedit.exe).
  2. Find the DLM Automation Suite registry keys.
    If you're running a 64-bit machine, they're in HKEY_LOCAL_MACHINE>SOFTWARE>Wow6432Node>Red Gate>DLM Automation Suite
    If you're running a 32-bit machine, they're in HKEY_LOCAL_MACHINE>SOFTWARE >Red Gate>DLM Automation Suite
  3. Set the enableFeatureUsageReporting and enableErrorReporting registry values to 0.

If you run a silent install to upgrade from an earlier version, we'll keep your previous SENDFUR and SENDERRORS settings.

SQL CI  2.1.4.42

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).

Add-on versions

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

SQL Release 1.2.4.66 

Feature

Simplified installation
SQL Release is now installed as part of the DLM Automation Suite, so you no longer need to run a separate installation process.

Known issue

We've had one report of SQL Release failing to pick up static data in the target database. You may have this problem if you see primary key violations, and a number of +INSERT statements in the static data section of the Changes.html file. 

We're working on a fix. In the meantime, the workaround is to open the creation script, look for the CREATE TABLE statement, and make sure there isn't an opening parenthesis directly after it on the same line. Scripts created using SQL Compare will not contain this formatting error. If you're editing the script, make sure the CREATE TABLE statement looks like this:

Good example

CREATE TABLE [dbo].[LookupAddressType]
(

and NOT like this:

Bad example

CREATE TABLE [dbo].[LookupAddressType](

DLM Dashboard

Features

  • 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 .
  • Use pipelines to group databases, so you can see schema changes across environments. 

  • Ignore changes to objects you're not interested in by adding filters to your pipeline. Filtered objects won't trigger updates or drift, and aren’t included in email notifications or reported on the Review page. 

For full details of features and fixes for DLM Dashboard, see DLM Dashboard release notes. 

Download DLM Dashboard

Command line tools for SQL Server

Features

  • New environment variables
    We've create a new environment variable to make maintaining references to tools easier. Use %DLMAS_HOME% whenever you need to reference the command line tool executables. 
  • We've also moved the default installation locations for SQL Compare and SQL Data Generator, so you must update existing references to these tools. For more information, see Updating references to DLM Automation Suite tools. 

 Releases

Didn't find what you were looking for?

Product Articles

Tips and how-to guides for Redgate products

University

Easy to follow video courses

Community Forums

Ask, discuss, and solve questions about Redgate's tools

Events & Friends

Meet us at an event, get sponsored, and join our Friends of Redgate

Simple Talk

In-depth articles and opinion from Redgate's technical journal