DLM Automation Suite

DLM Automation Suite 1.2 release notes

1.2.2.2705 - August 19th, 2015

This release contains new versions of:

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

 

1.2.1.2671 - July 29th, 2015

This release contains new versions of:

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

 

1.2.1.2650 - July 22nd, 2015

This release contains new versions of:

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.
T
o 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

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.
 

Tools Versions
Continuous integration NEW VERSION

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
Release management
SQL Release NEW VERSION 1.2.1.3109
SQL Release step templates

Tutorial

DLM monitoring
DLM Dashboard NEW VERSION

1.4.7
Download

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

Tools Versions
Continuous integration NEW VERSION

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
Release management NEW VERSION
SQL Release 1.2.1.3062
SQL Release step templates

Tutorial

DLM monitoring
DLM Dashboard NEW VERSION

1.4.0
Download

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

Tools Versions
Continuous integration NEW VERSION

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
Release management
SQL Release NEW VERSION 1.2.1.3032
SQL Release step templates

Tutorial

DLM monitoring
DLM Dashboard NEW VERSION

Download

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.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.
     
Tools Versions
Continuous integration NEW VERSION

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
Release management
SQL Release NEW VERSION 1.2.1.2943
SQL Release step templates

Tutorial

DLM monitoring
DLM Dashboard NEW VERSION

Download

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

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. 
Tools Versions
Continuous integration 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
Release management
SQL Release NEW VERSION 1.2.1.2869
SQL Release step templates

Tutorial

DLM monitoring
DLM Dashboard NEW VERSION

Download

Command line tools for SQL Server
SQL Compare NEW VERSION 11.2.3
SQL Data Compare NEW VERSION 11.2.3
SQL Data Generator 3.0
SQL Doc 3.0
SQL Packager 8.0

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.
Tools Versions
Continuous integration NEW VERSION

SQL CI

2.1.1.1051
TeamCity plugin 2.0.1.487
TFS Build plugin 2.0.2.344
TFS MSBuild scripts 2.1.1.1051
Release management
SQL Release NEW VERSION 1.2.1.2809
SQL Release step templates

Tutorial

DLM monitoring
DLM Dashboard NEW VERSION

Download

Command line tools for SQL Server
SQL Compare NEW VERSION 11.2.2
SQL Data Compare NEW VERSION 11.2.2
SQL Data Generator 3.0
SQL Doc 3.0
SQL Packager 8.0

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 
Tools Versions
Continuous integration NEW VERSION

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
Release management
SQL Release NEW VERSION 1.2.1.2726
SQL Release step templates

Tutorial

DLM monitoring
DLM Dashboard NEW VERSION

Download

Command line tools for SQL Server
SQL Compare NEW VERSION 11.2.1
SQL Data Compare NEW VERSION 11.2.1
SQL Data Generator 3.0
SQL Doc 3.0
SQL Packager 8.0

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.
Tools Versions
Continuous integration NEW VERSION

SQL CI

2.1.1.1048
TeamCity plugin 2.0.1.480
TFS Build plugin 2.0.2.340
TFS MSBuild scripts 2.1.1.1048
Release management
SQL Release NEW VERSION 1.2.1.2643
SQL Release step templates

Tutorial

DLM monitoring
DLM Dashboard NEW VERSION

Download

Command line tools for SQL Server
SQL Compare 11.2.0
SQL Data Compare 11.1.9
SQL Data Generator 3.0
SQL Doc 3.0
SQL Packager 8.0

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.

Tools Versions
Continuous integration NEW VERSIONS

SQL CI

2.1.1.1028
TeamCity plugin 2.0.1.480
TFS Build plugin 2.0.2.340
TFS MSBuild scripts 2.1.1.1028
Release management
SQL Release NEW VERSION 1.2.1.2602
SQL Release step templates

Tutorial

DLM monitoring
DLM Dashboard NEW VERSION

Download

Command line tools for SQL Server
SQL Compare NEW VERSION 11.2.0
SQL Data Compare 11.1.9
SQL Data Generator 3.0
SQL Doc 3.0
SQL Packager 8.0

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.

Tools Versions
Continuous integration

SQL CI

2.1.0.868
TeamCity plugin 2.0.0.456
TFS Build plugin 2.0.1.327
TFS MSBuild scripts 2.1.0.868
Release management
SQL Release 1.2.0.2423
SQL Release step templates

Tutorial

DLM monitoring
DLM Dashboard

Download

Command line tools for SQL Server
SQL Compare 11.1.4
SQL Data Compare 11.1.9
SQL Data Generator 3.0
SQL Doc 3.0
SQL Packager 8.0

 Releases

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:

Tools Versions
Continuous integration

SQL CI

2.1.0.811
TeamCity plugin 2.0.0.425
TFS Build plugin 2.0.1.317
TFS MSBuild scripts 2.1.0.811
Release management
SQL Release 1.2
SQL Release step templates

Worked example

DLM monitoring
DLM Dashboard

Download

Command line tools for SQL Server
SQL Compare 11.1.4
SQL Data Compare 11.1.9
SQL Data Generator 3.0
SQL Doc 3.0
SQL Packager 8.0

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

For installation instructions, see Installing.


Didn't find what you were looking for?