2.0.35 - April 11, 2018

Features:

• No longer installs localdb 2014 if a newer version is present
• Updates SQL Compare and SQL Data Compare to 13.3.2.

Fixes:

• Connections that previously reported application name as "Red Gate Software - SQL Tools" now report as "Redgate Software - DLM Automation".

2.0.34 - March 23, 2018

Fixes:

• Fixed an installer bug that could occasionally cause data loss

2.0.33 - March 21, 2018

Features:

• Updates SQL Compare and SQL Data Compare to 13.2.4.
• Updates SQL Data Generator to 4.0.3.
• Updates SQL Doc to 4.0.9.

For details of changes in these versions, please see their individual documentation pages.

Fixes:

• The DLM Automation Getting Started application no longer crashes on startup (fixes a regression introduced in 2.0.32)
• Fixed an issue where scripts with single quotes on an identifier would fail to be validated

2.0.32 - March 8, 2018

Known Issues:

The Getting Started application shipped with this version crashes on startup. This is fixed in version 2.0.33.
If you need to activate or deactive your serial number using version 2.0.32, you can work around this problem by using the Register-DlmSerialNumber and Unregister-DlmSerialNumber cmdlets.

Features

• Updates SQL Compare and SQL Data Compare to 13.2.2. For details of changes in these versions, please see their individual documentation pages.

Fixes:

• Bulk uninstaller improvements

2.0.30 - February 20, 2018

2.0.29 - February 14, 2018

Features:

• Updates SQL Compare and SQL Data Compare to 13.1.12. For details of changes in these versions, please see their individual documentation pages.

2.0.28 - January 31, 2018

Features:

• Integration with SQL Toolbelt bulk installer
• Updates SQL Compare and SQL Data Compare to 13.1.11. For details of changes in these versions, please see their individual documentation pages.
• Added server name to the difference reports in a database release

Fixes:

• Fixed an issue where the database comparisons were always being done with database folders instead of the actual source and target passed in

2.0.27 - January 12, 2018

Features:

• Updates SQL Compare and SQL Data Compare to 13.1.9. For details of changes in these versions, please see their individual documentation pages.

2.0.26 - December 12, 2017

Features:

• Updates SQL Compare and SQL Data Compare to 13.1.8. For details of changes in these versions, please see their individual documentation pages.

2.0.25 - December 7, 2017

Features:

• Updates SQL Compare and SQL Data Compare to 13.1.7. For details of changes in these versions, please see their individual documentation pages.
• Updates SQL Data Generator to 4.0.2. For details of changes in these versions, please see their individual documentation page.

Fixes:

• Fixed an issue where 0 timeout was being set to 30 seconds instead of infinite
• Fixed an issue where add ons where getting infinite timeouts instead of deafault timeouts

2.0.24 - November 22, 2017

Features:

• Updates SQL Compare and SQL Data Compare to 13.1.5. For details of changes in these versions, please see their individual documentation pages.

2.0.23 - October 25, 2017

Features:

• Updates SQL Compare and SQL Data Compare to 13.1.2. For details of changes in these versions, please see their individual documentation pages.

2.0.22 - October 11, 2017

Features:

• Updates SQL Compare and SQL Data Compare to 13.0.5. For details of changes in these versions, please see their individual documentation pages.
• SQL Compare now supports the HISTORY_RETENTION_PERIOD option on temporal tables
• The SQL Compare parser now accepts DATABASE SCOPED CONFIGURATION syntax.

Fixes:

• SC-9548: SQL Compare will now correctly create fulltext indexes if the IgnoreTransaction option is selected
• SC-9685: SQL Compare now uses DEFAULT instead of the text of your default when coercing nulls to a column's default value
• SC-9669: SQL Compare no longer lists differences in temporal tables' automatically generated columns, when static data is included in the comparison.
• SC-9700: SQL Compare wraps the default values of DateTime and DateTime2 parameters defined in a stored procedure in single quotes
• SC-9653: SQL Compare now supports the use of the non-reserved keyword MATCH, in the body of text objects.
• SC-9720/SC-9696: SQL Compare now handles comparison of whitespace and comments more consistently when the IgnoreWhitespace or IgnoreComments options are set.

2.0.20 - September 25, 2017

Fixes:

• Now encodes test results as UTF-8 so that Bamboo 6 is able to import them.
• Standalone installer UI updated (does not affect main bundle installer yet).

2.0.18 - August 31, 2017

Features:

• SQL Monitor integration - if you have SQL Monitor running on your server, it will pick up annotations when a release is deployed to that server. If you would like to turn this off, you can specify the -DisableMonitorAnnotation switch to the Use-DlmDatabaseRelease cmdlet.

Fixes:

• User specified timeout now respected when dropping a temporary database.

2.0.17 - August 11, 2017

Fixes:

• Fixes a situation where users could get stuck in a broken trial state even after activating

2.0.16 - August 10, 2017

Features:

• Update SQL Compare and SQL Data Compare to 12.4.10. This has initial 2017 support and fixes SC-9501 (overenthusiastic TEXTIMAGE_ON)

2.0.15 - August 3, 2017

Features:

• New-DlmDatabaseRelease and Use-DlmDatabaseRelease cmdlets can now be aborted if warnings are detected.
• New cmdlet added - New-DlmManualDatabaseSchemaValidation - which lets you bypass automatic schema validation.

2.0.14 - July 3, 2017

Features:

• New-DlmDatabaseDocumentation cmdlet now allows SQL Compare options to be specified.

Fixes:

• SqlCi.ps1 and CI system addins now correctly disable query batch timeout when the value is set to '0', rather than using default query batch timeout value

2.0.13 - June 22, 2017

Features:

• Update LocalDB to 2014.
• Updates SQL Compare and SQL Data Compare to 12.4.5, and Doc and Data Generator to 3.2.3. For details of changes in these versions, please see their individual documentation pages.

Fixes:

• UI now displays version number

2.0.12 - June 2, 2017

Features:

• Cmdlets that invoke SQL Compare can now ignore parser errors by using the -IgnoreParserErrors parameter
• Updates SQL Compare and SQL Data Compare to 12.4.1. For details of changes in these versions, please see their individual documentation pages.

Fixes:

• All Redgate assemblies are now digitally signed.

2.0.11 - May 24, 2017

Features:

• Updates SQL Compare and SQL Data Compare to 12.4.0. For details of changes in these versions, please see their individual documentation pages.

Fixes:

• Updated internal feature usage reporting library
• Error messaging improved when encountering some issues on attempting to clean a temporary database ready for schema validation.

2.0.9 - March 13, 2017

Features:

• Updates SQL Compare and SQL Data Compare to 12.2.1, SQL Doc to 3.2.1 and SQL Data Generator to 3.2.1. For details of changes in these versions, please see their individual documentation pages.

2.0.8 - February 20, 2017

Features:

• Add -PackageDescription to the New-DlmDatabasePackage cmdlet - this lets you specify the description of the NuGet package that you are creating.

Fixes:

• Intellisense on Powershell prompts and Powershell ISE now loads immediately rather than requiring one cmdlet to be input manually first.
• Static Data now excludes timestamp columns from comparison and deployment, allowing you to deploy the rest of the data in static data tables which contain them.

2.0.7 - January 16, 2017

Features:

• Updates SQL Compare and SQL Data Compare to 12.1.2. For details of changes in these versions, please see their individual documentation pages.

Fixes:

• SQLREL-138: Test execution now also obeys user-set query batch timeout value

2.0.6 - January 3, 2017

Features:

• Add -IgnoreAdditional to the Sync and New Release cmdlets - this lets you instruct DLMA to ignore additional objects in target databases when creating update scripts and deploying to databases.
• Unregister-DlmSerialNumber cmdlet added - this lets you deactivate a DLMA serial number from a machine you will no longer be using, to help manage your number of activations.
• Updates SQL Compare and SQL Data Compare to 12.1.0. For details of changes in these versions, please see their individual documentation pages.

Fixes:

• SQLREL-147: If a build fails, its auto-created temporary database is dropped.

2.0.5 - December 15, 2016

Features:

• Updates SQL Compare and SQL Data Compare to 12.0.39. For details of changes in these versions, please see their individual documentation pages.

2.0.4 - November 24, 2016

Features:

• SQL Compare command-line option "NoAutoColumnMapping" is now available.

Fixes:

• SQLCI-301 Register-DlmSerialNumber no longer crashes

2.0.3 - November 15, 2016

Features:

• New Dlm Automation UI, reduces install sizes

Fixes:

• SQLCI-299 Allow transaction isolation level to be specified for Build task

2.0.1 - October 19, 2016

Fixes:

• Updates to SQL Doc 3.1.2, SQL Data Generator 3.1.8, SQL Compare 12.0.34 and SQL Data Compare 12.0.34. For details of changes in these versions, please see their individual documentation pages.
• Fixed issue with newer SQL Data Generator project files being unreadable by DLM Automation

2.0.0 - September 29, 2016

Fixes:

• Sync-DlmDatabaseSchema now correctly synchronizes static data when using a NuGet package (.nupkg) as the source
• Import-DlmDatabasePackage no longer re-packs the imported package - it now provides the exact contents of the original package for exporting or publishing
• Invoke-DlmDatabaseSchemaValidation, New-DlmDatabaseDocumentation and Invoke-DLMDatabaseTests now support supplying filters using the -FilterPath parameter
• SQLCI-270: New-DlmDatabasePackage now excludes existing .nupkg files from the packaging process, to avoid ever increasing package sizes in certain continuous integration circumstances

Download DLM Automation add-ons