SQL Change Automation in SSMS

Release notes

3.3.19206.9616 - July 25th 2019

Improvements

  • Added a button toolbar on Manage Migrations page which will allow adding, editing and deleting files or folders from the project
  • Allow migrations to be ordered by the columns on the Generate Migrations page
  • Various UI fixes

Features

  • SCA-2626: Programmable object files will now be deleted from disk when their associated objects are removed from the project via an import
  • SCA-2616: Offline Schema Model files will now be deleted from disk when their associated objects are removed from the project via an import

3.3.19192.9312 - July 11th 2019

Features

  • Added the ability to remove projects from recently opened list
  • Added the ability to mark migration scripts as already applied

Improvements

  • Clicking on a recent project row will open the project

3.3.19189.9182 - July 8th 2019

Features

  • New homepage

Improvements

  • Removes workspaces and replaces the initial screen with a new homepage. This means that the history of previously opened workspaces is no longer shown, as the new homepage will now show the history of recently opened projects instead. As a consequence, the project (.sqlproj file) will need to be opened
  • Project setup dialog requires a project location to be set
  • Opening a project will navigate to the Generate migrations page

3.3.19177.8939 - June 26th 2019

Fixes

  • Fixed an issue where the product would not load in SSMS 18

3.3.19176.8883 - June 25th 2019

Improvements

  • New navigation bar to move between common actions (Generate migrations, Apply to database, View migrations, Verify) for a project.
  • The "Import to project" action has been renamed to "Generate migrations"

3.2.19165.8661 - June 17th 2019

Improvements

  • Added the ability to set the development database from the import, apply and verify pages

3.2.19158.8411 - June 7th, 2019

Fixes

  • Use preferred method for setting filter files in the project creation wizard. Instead of adding a setting in the .sqlproj file, copy the filter file to the project directory.

3.2.19157.8319 - June 6th, 2019

Improvements

  • When first opening the scripts overview only the migrations folder will be expanded
  • On the scripts overview, folders are now shown before files
  • When an error occurs on the scripts overview more information is provided
  • Improved keyboard navigation in the scripts overview
  • Changes to the development database connection string now displayed on the import page following a refresh

Fixes

  • When renaming a script or folder with illegal characters in the name a warning is now shown
  • Opening the scripts overview for a second time no longer causes an error
  • Double clicking no longer opens a script during a rename
  • When renaming a script or folder, the name is now selected correctly

3.2.19143.7910 - May 23rd, 2019

  • When there is an error deleting a script or a folder the error message is presented in the context of the scripts overview instead of navigating to an error page
  • Scripts overview will now silently refresh after operations
  • Preserves the state of the scripts overview after operations and navigation
  • Fixed various UI issues on renaming a script

3.2.19135.7673 - May 15th, 2019

  • Added feature usage reporting

3.2.19133.7564 - May 14th, 2019

  • SQL Change Automation now requires .NET Framework 4.7.2
  • The scripts overview will automatically refresh after a rename operation

3.0.19128.7456 - May 8th, 2019

  • Added feedback mechanism
  • Fixed an issue with creating a workspace in SSMS 18

3.0.19121.7310 - May 1st, 2019

  • Support for SSMS18

Features

  • Added the ability to add folders in the scripts overview
  • Added the ability to add migrations, programmable objects, pre-deployment scripts and post-deployment scripts in the scripts overview

3.0.19113.7105 - April 24th, 2019

Features

  • Added the ability to rename script files in the scripts overview
  • Added the ability to rename folders in the scripts overview

3.0.19095.6734 - April 5th, 2019

  • Fixed various issues with database connection dialog

3.0.19093.6661 - April 3rd, 2019

Features

  • Added the ability to delete folders from a project.
  • Workspace items can be opened in the file explorer.
  • Server and database discovery in database connection dialog.

3.0.19074.6071 - March 18th, 2019

Features

  • Added the ability to delete scripts from a project.
  • Added the ability to create a development database while setting up a project

Fixes

  • Can now change database while waiting for the connection to be validated in the project setup wizard

3.0.19056.5399 - February 25th, 2019

Fixes

  • Fixed an unresponsiveness issue after upgrading to the latest version.

3.0.19053.5376 - February, 22th, 2019

Features

  • Baselining now works for populated development databases
  • Scripts and unsupported object files generated as a result of baselining are now displayed after the process finishes

3.0.19051.5245 - February 20th, 2019

Features

  • New Manage Deployment Scripts Overview.
  • Programmable Objects are now shown in the order they appear in the file system rather than deployment order.
  • Set SQL Compare Filter Settings File to filter out objects.

Improvements

  • Renamed build to verify

Fixes

  • Fixed an issue where SQL parsing errors were not all being displayed

3.0.19042.4820 - February 11th, 2019

Features

3.0.19024.4247 - January 24th, 2019

Features

3.0.18334 - November 30th, 2018

Features

  • View the deployment scripts in a SQL Change Automation project
  • Specify an existing development database to work with
  • Import changes from a development database to a SQL Change Automation project
  • Apply changes made in a SQL Change Automation project to a development database

Didn't find what you were looking for?