Compliant Database DevOps

This page is here. The latest release announcements can be found here.

Included here are a selection of key database DevOps improvements. For a full and comprehensive list of product release notes, including bug fixes, please consult the release note pages for the individual components.

August 2019

SSMS experience in SQL Change Automation 4.0

SQL Change Automation version 4 allows you to create and manage migration scripts in SQL Server Management Studio. This allows teams to collaborate across Visual Studio and SSMS, and allows developers to work in their IDE of choice.

For more information, visit the SQL Change Automation release notes.

December 2018

Ignore Objects

Component(s) impacted: Deployment Suite for Oracle 5.2.0

It is already possible to filter down the list of objects in Schema Compare for Oracle and Source Control for Oracle. However, this filter applies after the tool reads the full schema, which, if large, can be time-consuming. The new Ignore Objects feature, available across the Deployment Suite for Oracle, allows schema objects that are known to be irrelevant to be explicitly excluded from the outset, which can dramatically improve performance.

For more information, see the documentation on using this feature for Schema Compare, Data Compare, or Source Control for Oracle.

October 2018

Static data deployment from source control

Component(s) impacted: Deployment Suite for Oracle 5

Source Control for Oracle v4 allowed static data to be stored in version control in csv format, which enables audit and version history as well as the sharing of changes among developers. Static data deployment takes this a step further and allows the versioned static data to be deployed alongside schema changes.

The /comparison:includeSourceTables command line switch has been added to the Data Compare for Oracle command line for cases where the target schema structure is different at the time of comparison (this would occur if you are generating schema and data deployment scripts ahead of the actual deployment step).

Optimization of refresh behavior in Source Control for Oracle

Component(s) impacted: Source Control for Oracle

The project refresh mechanism has been optimized as follows:

New "last refreshed" indicator appears on refresh button
Refresh no longer triggered automatically after commit/save/apply changes
Projects are refreshed only on first open

September 2018

Rollback support

Component(s) impacted: SQL Compare 13, SQL Change Automation 3

SQL Compare and the SQL Compare command line can now read in a SQL Change Automation project, allowing rollback scripts to be created. This can be scripted as part of a deployment pipeline, by generating a rollback script artifact based on the comparison of the production state against the SCA project.

Eg, sqlcompare.exe /db1:WidgetProduction /sca2:"C:\ScaProject\ScaProject.sqlproj" /scriptFile:"Rollback.sql"

April 2018

Table Mapping added to Data Compare 4

Component(s) impacted: Data Compare for Oracle

Improved "Tables & Views" tab dialog, with support to map tables of different names. See documentation.

November 2017

Static Data support

Component(s) impacted: Source Control for Oracle 4.05

Static data can now be checked in to version control. Data Compare for Oracle v5 will be able to deploy these static data changes against a target database.

September 2017

Component(s) impacted: Source Control for Oracle SQL Compare 13 and SQL Monitor 7.1

SQL Compare now appends a logging statement at the end of the deployment script to log the deployment details to SQL Server Log in order for SQL Monitor to detect the deployment and mark it on the timeline for performance data. Note that this feature should be regarded as a preview and is therefore subject to change. This is expected to be a SQL Toolbelt-licensed feature. Find out more in this How-to guide.