1.2.2.2705 - August 19th, 2015

This release contains new versions of:

• SQL Release
• SQL CI
• DLM Dashboard

SQL Release 1.2.3.3168 

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

SQL CI  2.1.3.1183

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

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

• SQL Compare 11.2.8
  
• SQL Data Compare 11.2.6
• SQL Data Generator 3.0
• SQL Doc 3.0
• SQL Packager 8.0

1.2.1.2671 - July 29th, 2015

This release contains new versions of:

• SQL CI, the TeamCity and TFS Build plugins, and MSBuild scripts
• SQL Release
• SQL Compare command line
• SQL Data Compare command line

SQL CI  2.1.2.1168

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

SQL Release 1.2.2.3142 

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

DLM Dashboard 1.4.8

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

Download DLM Dashboard

Command line tools for SQL Server

• SQL Compare 11.2.6
  
• SQL Data Compare 11.2.6
• SQL Data Generator 3.0
• SQL Doc 3.0
• SQL Packager 8.0

1.2.1.2650 - July 22nd, 2015

This release contains new versions of:

• SQL Release
• SQL CI
• DLM Dashboard
  

SQL Release 1.2.2.3123 

We've added another new feature to the SQL Release step templates for Octopus Deploy.

Feature

Last week we added a TemporaryDatabaseServer parameter to the New-DatabaseRelease cmdlet. This week we've added a Temporary database server connection string parameter to the following step templates for Octopus Deploy:

• Redgate - Create Database Release
• Redgate - Deploy from Package

If you're using Migrations V2 beta, you can use the new parameter to specify the connection string of the SQL Server instance for a temporary database, instead of using LocalDB. This allows Migrations V2 beta to work with databases that have features not supported by LocalDB, such as Full-Text Search.

The latest versions of the step templates are available from the Octopus Deploy Library.
To learn more about installing and using the SQL Release step templates, see this worked example. 

SQL CI  2.1.2.1157

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) 

DLM Dashboard

You can now rename schemas from the History 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

• SQL Compare (11.2.3)
  
• SQL Data Compare (11.2.3)
• SQL Data Generator (3.0)
• SQL Doc (3.0)
• SQL Packager (8.0)

1.2.0.2644 - July 15th, 2015

This release contains new versions of:

• SQL Release
• SQL CI
• DLM Dashboard
  

Feature

SQL Release: for users of Migrations V2 beta, we've added a parameter to the New-DatabaseRelease cmdlet that you can use to specify an alternative instance for a temporary database.
 

1.2.0.2636 - July 8th, 2015

This release contains new versions of:

• SQL Release
• SQL CI
• DLM Dashboard
  

Feature

• SQL Release: we've added some new parameters to the Redgate step templates for Octopus Deploy.
  
  

1.2.0.2622 - July 1st, 2015

This release contains new versions of:

• SQL Release
• SQL CI
• DLM Dashboard

Feature

• SQL Release: the Export-DatabaseRelease cmdlet now supports the -Force parameter, allowing you to overwrite any previous export.
  
  

1.2.0.2600 - June 24th, 2015

This release contains new versions of:

• • SQL Release
  • SQL CI

Features

• SQL Release: we've improved navigation in the Changes.html report.
• SQL Release: you can now choose whether to include identical objects in the Changes.html report.
   

1.2.0.2582 - June 17th, 2015

This release contains new versions of:

• SQL Release
• DLM Dashboard
  
• SQL Compare command line
• SQL Data Compare command line
• SQL Compare engine that powers SQL CI and SQL Release

Features

• SQL Release: the Changes.html report that's created as part of the database deployment now includes tabs for deployment warnings and the update script.
• SQL CI: 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. 

1.2.0.2562 - June 10th, 2015

This release contains new versions of:

• SQL Release
• DLM Dashboard
  
• SQL Compare command line
• SQL Data Compare command line
• SQL Compare engine that powers SQL CI and SQL Release

Features

• SQL Release: the Changes.html report that's created as part of the database deployment resources now includes static data changes.
• SQL Compare: the SQL Compare engine now runs as a 64-bit process on a 64-bit OS.

1.2.0.2548 - June 3rd, 2015

This release contains new versions of:

• SQL Release
• DLM Dashboard
  
• SQL Compare command line
• SQL Data Compare command line
• SQL Compare engine that powers SQL CI and SQL Release

Features

• SQL Release: we've improved the look and feel of the Changes.html report that's created as part of the database deployment resources. 
• DLM Dashboard: notifications are quicker to set up now that DLM Dashboard guesses your email address based on your Windows account and computer's domain. 

Fixes

SQL Compare 11.2.1 contains a number of fixes, including:

• SC-5533 - Permission changes for system users (e.g. 'guest') are now correctly ignored when the "ignore users’ permissions and role memberships” option is selected 

1.2.0.2532 - May 27th, 2015

This release contains new versions of:

• SQL Release
• DLM Dashboard
• SQL CI, the TeamCity and TFS Build plugins, and MSBuild scripts (internal changes only)

We're also excited to announce that DLM Dashboard is out of beta. The version linked from the DLM Automation Suite lets you monitor up to five databases. 

Features

• SQL Release: static data is now included in the pre-deploy schema check.
• DLM Dashboard: you can now turn off feature usage reporting.

1.2.0.2521 - May 20th, 2015

This release contains new versions of:

• SQL Compare command line
• SQL Compare engine that powers SQL CI and SQL Release

Features

SQL Compare 11.2.0 provides lots of new features, including:

• support for full-text catalogs created before transactions being in deployment scripts.
• support for filter rules using two new match operators, Like and Not like, in addition to the existing operators.

Fixes

SQL Compare 11.2.0 also fixes many bugs, including:

• SC-1196 - SQL Compare now deploys full-text indexes in the correct order as long as transactions are turned off
• SC-7621 - Built-in function is no longer treated as an object when comparing two schemas
• SC-7632 - System functions are no longer incorrectly scripted with brackets

For more details, see the SQL Compare 11.2 release notes.

1.2.0.2474 - April 22nd, 2015

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

The DLM Dashboard (linked under DLM monitoring in the DLM Automation Suite app) is the only tool that's had features added since the last version was released.  For more details, see the DLM Dashboard release notes.

1.2.0.2409 - March 31st, 2015

This is the first release of the DLM Automation Suite, which replaces the SQL Automation Pack. It includes the following tools:

For details of how to upgrade from the SQL Automation Pack, see Upgrading.

For installation instructions, see Installing.