1.14.22 - November 21st, 2017

Fixes

• Fix generation of HTML reports during preview and drift builds
• Minor fixes to build logging

1.14.21 - November 15th, 2017

Fixes

• Fix Object reference not set to an instance of an object error during Import when BaselineUptoMigrationId property in the project file is invalid
• Fix crash when solution is closed or project unloaded during Refresh/Import
• Fix crash in some situations when a database is offline or otherwise inaccessible
• Fix issue where initial import fails if SemVer was enabled beforehand

Improvements

• Improve error and crash reporting to ReadyRoll development team
• Make Programmable Objects deployment order box expandable in project properties page
• Minor changes to build logging

1.14.20 - October 31st, 2017

Fixes

• Fix Object reference not set to an instance of an object when the Revert command is used in the ReadyRoll tool-window, and when Drift analysis is performed in a CI build
• Prevent invalidation of the schema snapshot during execution of the Drift "resync" script

1.14.19 - October 25th, 2017

Fixes

• Fix Snapshot deployment when MigrationLogSchemaName property is set

Improvements

• Add new package script SQLCMD variable: IsShadowDeployment
• Generate deployment preview report even if there are no schema changes
• Upgrade SQL Compare Engine

1.14.18 - October 17th, 2017

Fixes

• Fix an issue where SQL comments could be duplicated in the package deployment script
• Fix exception on solution close
• Fix an issue where the ReadyRoll window wouldn't behave correctly with multiple ReadyRoll projects in a solution
• Install successfully from the .exe installer when VS2017 is updating extensions in the background
• Remove the installer running the wrong version of VS

Improvements

• Improve generation of the drift report so it includes programmable objects correctly
• Drop the shadow database during a Clean (or Rebuild)
• Error the build if BaselineUpToMigrationId is set to invalid value when compiling in Visual Studio
• Improve MSBuild messaging when invalid connection string provided
• Improve styling on the Verification Failed screen
• Remove support for ignoring build cancellation
• Simplify ReadyRoll.Data.Schema.SSDT.targets
• Upgrade to a supported version of Microsoft.Web.Xdt
• Switch to the .NET 4 version of Microsoft.Expression.Interactions.dll
• Add the ReadyRoll icon to the ReadyRoll.MSBuild NuGet package

1.14.17 - October 3rd, 2017

Fixes

• Fix issue where [Unknown] was shown instead of the database server and name after project reload
• Fix issue where using the non-reserved keyword MATCH in a script would cause an error
• Fix issue where renaming the active project would cause the project dropdown to stop showing it

Improvements

• Diff report now shows changes to Programmable Objects. In order for this feature to work, the deployment script saves a schema snapshot to the target database
• Display more informative error message if a filegroup is required in a migration script
• Improve the look and feel of the installer

1.14.16 - September 27th, 2017

Fixes

• Disable transactions when Memory-Optimized Tables are present in the migration script
• Fix issue with script verification failing after initial import
• Fix issue where UI elements would render as black window
• Fix incremental sqlproj builds when outputting SqlCmd packages
• Various fixes and improvements to the SQL Compare engine
• ALTER statements aren't duplicated if SyncOptionIncludeExistenceChecks option is set
• Fix issue where the options SyncOptionIgnorePermissions, SyncOptionIgnoreAnsiOptions, SyncOptionIgnoreConstraintWithNoCheckAttribute would be ignored

Improvements

• Remove support for renaming migration log table and view; multiple tables can be distinguished by setting the schema name using the MigrationLogSchemaName property
• Retire support for SQL Server 2005

1.14.15 - September 13th, 2017

Fixes

• Fix issue where SqlCmd process keeps running when the Build...Cancel command in Visual Studio is used during deployment
• Fix issue where SqlCmd process keeps running when a Continuous Integration build is halted, or when CTRL-C is used during MSBuild command line execution
• Fix issue where a Verification Error dialog shows out-of-date error message
• Prevent error when retrying connection to server fails
• Prevent Visual Studio process from terminating when user cannot connect to a SQL Server instance during build

Improvements

• Write the ReadyRoll version to the output during build
• Improve message when ReadyRoll encounters an error
• Improve build-time validation messages when a T-SQL execution error occurs

1.14.14 - September 5th, 2017

Fixes

• Prevent Visual Studio from freezing during build in certain virtual environments
• Prevent Thread was being aborted errors upon build cancellation

1.14.13 - August 30th, 2017

Improvements

• Preparation work for upcoming SQL Monitor integration
• Display message when refresh is needed before sync
• Show connection dialog in VS 2017 Update 3 (15.3) without opening project properties

1.14.12 - August 22nd, 2017

Fixes

• Prevent error from occurring when attempting to checkout files from source control
• Fix issue with viewing synchronization script when migrations have been modified
• Fix bug when opening connection dialog in Visual Studio 15.3

1.14.11 - August 11th, 2017

Fixes

• Fix a bug where Offline Schema Model is wrongly turned on after project unload and reload
• Fix a bug where a deadlock occurs when selecting a project from the dropdown in a multi-project solution

Improvements

• Remove limitations on Azure script generation (Fulltext indexing, Extended properties, FILLFACTOR, NOT FOR REPLICATION)

1.14.10 - August 8th, 2017

Fixes

• Fix a build error when the SET IDENTITY_INSERT statement is in a separate batch than the INSERT statements. For existing projects, please upgrade your project file to the latest deployment strategy as outlined in this article

Improvements

• New strategy of generating package deployment scripts enabled by default for new projects which may result in faster deployments
• Display more specific error messages when the connection to development database fails
• Support SQL Server 2017 syntax when targeting Azure
• Improve syntax highlighting of the Scripts tab in the deployment preview report
• Add link to Redgate Hub under Help menu
• Redesign warning views

1.14.9 - August 2nd, 2017

Fixes

• Ensure files are checked out from source control during import when using TFS
• Verify SQLCMD variables (including custom variables in the .sqlproj) are defined in the package deployment script before starting a transaction

Improvements

• No longer open project properties when configuring the connection
• Display warning view when attempting to modify files locked by other users in TFS

1.14.8 - July 26th, 2017

Fixes

• Fix resource leak that could result in an OutOfMemoryException
• Fix drift detection or schema revert issue with SQLCLR assemblies
• Fix deployment failure due to missing CREATE DATABASE script

Improvements

• Raise descriptive error message when trying to run the package script against Azure database in SSMS
• When using Azure as a sandbox database, use default connection for shadow database
• When using Azure as a sandbox database, automatically save the appropriate SQL Server version to the .sqlproj

1.14.7 - July 11th, 2017

Fixes

• Pending deployment view no longer flickers
• SyncToOfflineSchemaModel property is only added to .sqlproj file

1.14.6 - July 4th, 2017

Fixes

• Fix "constraint not found" error during deployment of Migration Log
• Edit connection dialog on cancel does not change active project in multi-project solutions
• Import programmable objects option is saved for correct project in multi-project solutions

Improvements

• Enable Offline Schema Model by default in Pro Edition
• Upgrade OctoPack to the latest version (3.6.1)
• Add possibility to provide a version of OctoPack to be used by specifying the OctoPackTargetsPath option
• Improve performance on populating the pending changes list

1.14.5 - June 27th, 2017

Fixes

• Change list view no longer flickers on refresh
• Long database names are truncated and don't go off the screen

Improvements

• Added option (OctoPackAppendDateToDescription) to allow appending the creation date to the OctoPack package description
• Re-designed error view
• ReadyRoll upgraded to .NET 4.6.1
• Migration scripts are now always saved on refresh

1.14.4 - June 13th, 2017

Fixes

• Fix scenario where some data changes wouldn't show after a Refresh
• Fix edge case scenario where it would be impossible to dismiss the error view

Improvements

• Redesign progress view

1.14.3 - June 7th, 2017

Fixes

• Regression where all SQL files would no longer be treated as migrations when additional scripts folder is defined
• Summary for all deleted objects is now being shown in the pending changes list

Improvements

• Major performance improvement on project refresh

1.14.2 - June 1st, 2017

Improvements

• Re-designed home screen
• Update the SQL Compare Engine
• During builds, we now report a warning if the target database doesn't exist

1.14.1 - May 25th, 2017

Fixes

• Regression where the OctoPack folder would no longer be included under the MSBuild folder, which caused projects that were configured to generate OctoPack packages to fail to load
• Prevent including static data for tables that don't have a primary key

1.14.0 - May 23rd, 2017

Improvements

• Replace script status widget with action bar
• Set Programmable Object deployment order automatically during initial import
• Improve appearance of list of database changes
• Add build-time support for SQL Server 2017 language features
• Add support for SQL Server 2016 SP1 language features, such as the CREATE OR ALTER PROC syntax
• Improve loading time of Project Properties
• Remove EULA dialog on first use
• Remove the ellipses from actions that happen immediately

Fixes

• Fix error during static data import when table is renamed/dropped
• Stop suggesting the use of Programmable Objects if none exist
• Only suggest the use of Programmable Objects once per project
• Stop showing invalid objects in the Deployment Order list
• Fix tab order in Project Properties
• Save settings to correct project in multi-project solutions