SQL Compare 12

SQL Compare 12.0 release notes

What's new in SQL Compare 12.0

New user interface (UI)

We’ve completely overhauled the UI of SQL Compare to align it with our new common design guidelines. This has also allowed us to spend some time improving the underlying codebase, fixing over 200 UI related bugs in the process. This latest release sets us up to make small, quick improvements to the user experience.

 

Parallel registration

When registering from a live database, scripts folder, or a snapshot, SQL Compare will now register both data sources at the same time, rather than waiting for your source to finish before starting on the target. This should speed up the comparison considerably.

 

 

Login based licensing

You’ll notice SQL Compare asks you to sign in when you launch v12. That’s because we’ve introduced user account licensing, which will make it much easier for you to keep track of the tools you own and to move them between different machines.

SQL Server 2016 Support

SQL Compare 12 includes support for the following SQL Server 2016 features:

  • JSON syntax

  • Columnstore indexes on memory optimized tables

  • Dynamic Data Masking

  • Row Level Security

  • Stretch Tables

Next up we’ll be tackling support for Temporal Tables.

Removed features in SQL Compare 12

  • SQL Server 2000 support

  • The fast deploy project option

  • Print preview of the comparison results (“Tools -> Generate comparison results report” should now be used instead)

12.0.40.3714 - December 6th 2016

FREQUENT UPDATES RELEASE

Features

  • SQL Compare has a new 'my projects' dialog accessible from the File menu. The new dialog can also be made to show by default at startup.
  • SC-8950: SQL Compare now accepts /scriptsfolderxml1 and /scriptsfolderxml2 switches (to give different source control information for each database)
  • The diff viewer now uses yellow highlighting rather than blue

Fixes

  • SC-9111: SQL Compare no longer attempts to fetch the SQL Source Control revision number for a database if it is not in the list of databases for that server. This fixes a bug where typing in the database name would cause repeated failed login attempts.
  • SC-9136: SQL Compare now correctly handles stored procedure parameters with negative defaults
  • SC-9130: Fix a bug where custom filters were not always saved correctly

12.0.39.3632 - November 23th 2016

FREQUENT UPDATES RELEASE

Features

  • SQL Compare now correctly parses SELECT statements using the FROM OPENJSON (...) WITH syntax
  • Updated SQL Compare with new event types introduced in a recent Azure SQL Database update

Fixes

  • SC-9134: SQL Compare no longer crashes when comparing windows users that differ in case when the case-sensitive object definition option is set
  • SC-9092: SQL Compare will no longer display progress values greater than 100% during registration in the mappings UI
  • SC-9120: SQL Compare will no longer highlight whitespace differences in the difference pane if the Ignore white space option is set
  • SOC-8087: Using migrations no longer causes a crash if git is not installed

12.0.38.3582 - November 15th 2016

FREQUENT UPDATES RELEASE

Features

  • SQL Compare now supports create, alter and drop EXTERNAL RESOURCE POOL syntax in SQL Server 2016
  • SQL Compare now supports the CONTAINMENT = NONE/PARTIAL syntax in SQL Server 2016

Fixes

  • SC-9117: SQL Compare no longer crashes when several windows users with the same name but different domain names exist in the same database
  • SC-9112: SQL Compare will now successfully compare user defined types named "TableType" between a database and script folder.
  • SC-9090: SQL Compare now detects the dependency between a computed column in a table and the function
  • RGC-248: Licensing dialogs are more usable in High DPI mode

12.0.37.3561 - November 10th 2016

FREQUENT UPDATES RELEASE

Features

  • SQL Compare now has a project-level option, NoAutoColumnMapping, to disable automatic mapping of similarly named columns in mapped tables.

Fixes

  • Fixed sorting of "last modified date" column
  • SDC-2225: Improved cleanup of temporary files when deploying to scripts folders

12.0.36.3534 - November 7th 2016

FREQUENT UPDATES RELEASE

Features

  • Improved Check for updates UI - available updates are now a lot more obvious, there are more options for ignoring updates and the installation process has been streamlined

  • SQL Compare now supports the DATABASE SCOPED CREDENTIAL syntax in SQL Server 2016

  • SQL Compare now supports the ALLOW_ENCRYPTED_VALUE_MODIFICATIONS syntax creating users in SQL Server 2016

  • SQL Compare now supports syntax to create stretch tables in SQL Server 2016

  • SQL Compare now supports the DROP IF EXISTS syntax for dropping objects in SQL Server 2016

Fixes

  • SC-9089: It is now possible to create databases on Azure SQL Database using SQL Compare

  • SC-8123: Creating a database on an Azure server no longer hits a timeout

12.0.35.3485 - October 31th 2016

FREQUENT UPDATES RELEASE

Features

  • For tables, views, functions and stored procedures, the differences grid now shows the last modified date
  • SQL Compare now records the last modification date for tables, views, functions and stored procedures
  • SQL Compare now supports the FILTER_PREDICATE keyword altering tables on stretch databases
  • SQL Compare now supports the SQL Server 2016 syntax for truncating a table with the PARTITIONS option

Fixes

  • SC-9069: Fixed a problem when registering a backup in 2K compatibility mode

12.0.34.3467 - October 26th 2016

FREQUENT UPDATES RELEASE

  • SC-9071: Avoided a possible crash when calculating table drops
  • SC-9062: Fixed an issue where SQL Compare could forget a selected revision number for a SQL Source Control data source when editing an already-compared project
  • SC-9061: SQL Compare now adds the SQL Source Control revision number to the deployment script comment header, if available
  • SC-9085: Fixed a bug where spaces could be appended to the end of multiline statements when saving a deployment script to a file
  • SC-9060: SQL Compare now allows arbitrary revision numbers to be typed into the SQL Source Control data source UI.
  • SC-9088: Typing in the database in the Edit Project dialog will now scroll to that database in the dropdown
  • SC-9086: SQL Compare no longer shows region marker comments as different in the text diff when there are other differences in that region

12.0.33.3389 - October 17th 2016

  • SC-7709: Improved usability on high DPI monitors
  • SC-8933, SC-7963, SC-9031: Errors or inconsistencies detected during registration are no longer incorrectly reported with the message "a duplicate object name has been found". Instead, more helpful descriptions of the errors are given.
  • SC-9053: sqlcompare.exe will now correctly fail with exit code 63 (databases identical) if the only changes to deploy are migration scripts and IgnoreMigrationScripts is specified as an option
  • SC-9057: Fixed a case where objects could be sorted inconsistently when sorting by the left object name
  • SC-9058: SQL Compare now accepts the [date] AT TIME ZONE [timezone] syntax
  • SC-9059: Fixed a case where fetching the list of databases would fail when the server name contained custom connection string parameters
  • SC-9065: Fixed a crash that could occur when comparing a SQL user to a Windows user

12.0.32.3340 - October 10th 2016

FREQUENT UPDATES RELEASE

  • SC-8716: Indexes on a column are not recreated when the only change to the column is the modification of a DEFAULT constraint
  • SC-8894: Fix exception in the deployment wizard when displaying messages not linked to objects.
  • SC-8998: SQL Compare now restores the main window position and size more reliably
  • SC-8959: Fixed an issue where SQL Compare would attempt to connect with the wrong credentials while loading the SQL Source Control revision number from a database
  • SC-9041: Allow saving and opening projects with automatically mapped tables and columns
  • SC-9037: Double clicking on the comparison banner will now change the deployment direction
  • SC-9045: No longer throw an exception when mapping previously unmapped columns
  • SC-8997: The deployment wizard button is now disabled if there are no differences to deploy
  • SC-9026: Fix exception on using the /out flag in the command line.
  • SC-9021: Projects created by the SSMS integration pack will now load your default options
  • SC-9038: Fixed an issue where switching the deployment direction could forget some object selections
  • SDC-2210: The mappings UI now supports selecting or deselecting multiple rows using the mouse (previously this would only work with the spacebar)
  • SDC-2211: Some of the table layouts in the Edit Project dialog have been tweaked to make better use of space
  • SDC-2212: The UI now shows a spinny while generating a deployment script
  • SDC-2213: The UI now shows the deployment script in black while generating the syntax highlighting
  • SC-9044: Improved error handling on open file dialogs when a default directory can not be found
  • Comparison summary dividers and tooltips now show the full server and database name

12.0.31.3232 - October 3th 2016

FREQUENT UPDATES RELEASE

  • SC-8702: Users named after Windows principals are now equal even if their domains are different
  • SC-8409: Fixed a crash when failing to fetch encrypted object text
  • SC-9003: Correctly identify differences in stored procedures with comments between create statement and object name
  • SC-8965: Include existence checks for roles in the deployment script, when "Add object existence check" is specified.
  • SC-9017: Show dropped items separately in the summary pane of the deployment wizard
  • SC-8990: Fixed a crash when failing to list SQL Server instances
  • SC-9000: SQL Compare now applies filter criteria when generating reports

12.0.30.3199 - September 27th 2016

  • SC-7709: Improved the appearance of the title bar in high DPI mode
  • SC-9897: Fixed a crash when displaying a partially-formed source control location.
  • Fixed multiple issues saving and loading custom filters.
  • SC-9009: Textual objects containing empty lines on one side of the comparison will no longer cause errors in the diff viewer

12.0.29.3182 - September 22th 2016

FREQUENT UPDATES RELEASE

  • SC-8990: Exceptions occuring during SQL Server instance discovery will no longer bubble up into the UI
  • SC-8993: Fixed a bug which would cause Compare to show dependencies in the deployment wizard which weren't linked to deployable differences
  • SC-8988: Command line now uses specified options when making snapshots
  • SC-8995: Allow source control as a source or target when using the command line
  • SDC-2195: Fixed a crash in the project config dialog when right-clicking in the database dropdown
  • SC-9004: Custom connection string properties can now be passed by adding them to the server name on the connection dialog
  • SC-8955: SQL Compare now handles exceptions that occur while trying to set clipboard text while another application is locking the clipboard

12.0.28.3138 - September 19th 2016

  • SC-8989: Fixed filter checkboxes for projects loaded using the SSMS Integration Pack
  • SC-8939: Use fully qualified name of table types columns in table definitions

12.0.27.3125 - September 15th 2016

  • SC-8953: Projects loaded using the SSMS Integration Pack now load with the correct 'Nothing excluded' filter
  • The default file name for snapshots taken in the deployment wizard now contains a timestamp

12.0.26.3104 - September 15th 2016

FREQUENT UPDATES RELEASE

  • SC-8951: Prevented the object diff view from jumping around when selecting differences at the end of the list
  • SC-8948: When renaming a table and a column in the same deployment the correct existence check will now be written in the deployment script.

12.0.25.3064 - September 13th 2016

FREQUENT UPDATES RELEASE

  • SDC-2193, SC-8964, SC-8973: SQL Compare now correctly ignores whitespace in comments when "ignore whitespace" option is used
  • SC-8970: Fixed spelling of "deployment" in the "Don't use transactions" option description

12.0.24.3012 - August 25th 2016

FREQUENT UPDATES RELEASE

Fixes

  • SC-8936: Fix a bug where in the deployment wizard where the name and path of the sync script were being ignored.
  • SC-8935: Add a timestamp to the filename for sync scripts to match the behaviour of SQL Compare 11.
  • SC-8930: Make schema table mapping view display 'full' and 'partial' correctly
  • SC-8910: Fix a rare crash while loading the schema to edit the mappings

12.0.23.2976 - August 25th 2016

FREQUENT UPDATES RELEASE

Fixes

  • SC-8928: The mappings step for a comparison no longer causes the UI to hang in a database with many tables
  • SC-8642: Recently used projects are now added to the program jumplist in Windows 10
  • SC-8922 Fixed viewing/saving/copying the deployment script when a text object uses nonstandard line endings
  • SC-5275: Added keyboard support to the table mapping grids
  • SDC-2181: The deployment script comment header will now show the UI version instead of the compare engine version.
  • SC-8907: Excluded spammy log messages caused by attempts to resolve resource assemblies

12.0.22.2910 - August 22nd 2016

 FREQUENT UPDATES RELEASE

Fixes 

  • SC-8731: Fixed a graphical glitch in the Create snapshot dialog when backups were used as a data source but no backup files were selected
  • SDC-2174: Support changing comparison direction on comparisons involving backup data sources
  • SC-8620: Long error messages will no longer cause the "more details" dialog to be taller than your primary monitor
  • SDC-2124, SDC-2125: Show ellipsis correctly when column or table name get too long in mappings window

12.0.21.2819 - August 16th, 2016

FREQUENT UPDATES RELEASE  

Fixes

  • SC-8235: You can now search and paste paths when opening folder locations
  • SC-8733: A message is now shown when there are no deployment warnings
  • SC-8724: The folder location is now shown rather than database name in the summary line of the source control data source

12.0.20.2791 - August 11th, 2016

FREQUENT UPDATES RELEASE  

Fixes

  • SC-8831: SQL Compare now understands the LINENO statement.

12.0.19.2758 - August 9th, 2016

FREQUENT UPDATES RELEASE  

Fixes

  • SC-8900: Databases are now referred to as 'source'/'target' rather than 'first'/'second' throughout the application.
  • SC-8904: Prevented an undeployable difference that could occur when a stored procedure was created with a lowercase CREATE keyword.
  • SC-8505: The "Ignore WITH element order" option will now correctly ignore the order of items in a WITH clause.
  • SC-8099: Non-breaking spaces are now ignored in extended property values when the "Ignore whitespace" option is on.
  • SC-8899: When changing deployment direction on a new project, any project open will not also change deployment direction.

12.0.18.2723 - August 5th, 2016

FREQUENT UPDATES RELEASE  

Fixes

  • SC-8898: Fixed a bug that prevented swapping direction in the Edit Project window in some cases where a comparison had not yet been performed.

12.0.17.2708 - August 4th, 2016

 FREQUENT UPDATES RELEASE  

Fixes

  • SC-8732: The 'enter' key now searches in the find box in the deployment script view.

12.0.16.2688 - August 3rd, 2016

 FREQUENT UPDATES RELEASE  

 Fixes

  • SC-8891, SC-8892: SQL Compare will no longer treat compatibility level 80 as a 2000 database when checking for deprecated versions.
  • SC-8886: Open project dialog can now read both Compare and Data Compare project files.
  • SC-8413: Fixed an error generating a deployment script when your repository contains migration scripts.
  • Additional logging for errors during deployment when your repository contains migration scripts.
  • SC-8866: The progress dialog now gives a better indication of exactly which subtask failed, if any.

12.0.15.2659 - August 2nd, 2016 

FREQUENT UPDATES RELEASE  

Fixes

  • SC-8880: Fixed a crash when copying/moving scripts folders in the connection dialog

12.0.14.2614 - July 28th, 2016

FREQUENT UPDATES RELEASE 

Features

  • SQL Server 2000 databases are no longer supported.
  • The migrations v2 beta is no longer supported

Fixes

  • SC-8840: Fixed a bug where trials were reported as standard edition, causing the commandline to be unavailable
  • SC-8838: The 'Ignore migration scripts for databases' option will now correctly disable SQL Source Control 5 migrations
  • SC-4381: SQL Compare now displays nested multiline comments properly in the difference pane
  • SC-8820: 'Recently used' lists will now store up to ten items.
  • SC-8854: Prevented a crash that could occur when registering a scripts folder containing a function with a complex series of aliases.
  • SC-8042: Add check to avoid putting default permission for user defined types twice in the permission list
  • SC-8850: The state of the 'deploy all dependencies' checkbox in the deployment wizard is now persisted (on a per-project basis).

12.0.12.2546 - July 22nd, 2016

Fixes

  • SC-8809: Mappings work consistently when deploying in either direction
  • SC-8722: SQL Compare now registers permissions on sequence objects from scripts folders.
  • SC-8832: Excluding dependencies in the deployment wizard now works as expected
  • SC-8830: The deployment wizard will no longer crash when a difference matching an object changed by the deployment script cannot be found

This build also rolls up fixes from recent Compare v11 versions:

  • SC-8668: SQL Compare no longer generates incorrect creation script for objects using WITH ENCRYPTION option when AS keyword not specified
  • SC-8421: Dependencies now correctly calculated from ALTER SCHEMA statements.
  • SC-8777: Data compression differences now picked up when Ignore filegroup, partition scheme and partition function option used
  • SC-8735: Default values for parameters of type BINARY can now be registered from live databases
  • SC-8667: Default parameters no longer cause an overflow exception for large (>3.4E38) values
  • SC-4447: Default parameters no longer cause an overflow exception for large (>3.4E38) values
  • SC-8702: Users are now regarded as equal if they are Windows principals on different domains
  • SC-8353: Compare no longer forgets to add columns when rebuilding a fulltext index on a view
  • SC-8671: Compare now correctly scripts out computed columns that call functions with DEFAULT parameters
  • SC-8665, SC-8392: System functions added in Sql Server 2016 are no longer escaped when deploying to a scripts folder
  • SC-8632: SQL Compare no longer treats change_tracking_current_version as a column name in constraints
  • SQL Compare now detects that a table is dependent on a function when the function is used in a check constraint

12.0.10.2453 - July 15th, 2016

Fixes

  • All users are now eligible for a new 14 day trial

12.0.9.2436 - July 14th, 2016

Fixes

  • SC-8791: Mapping two tables in the same schema when that schema is unmapped now keeps the mapping in the comparison

12.0.8.2363 - July 12th, 2016

Features

Fixes

  • SC-8763: The deployment progress dialog no longer sometimes fails to report successful completion.

12.0.7.2257 - June 30th, 2016

Fixes

  • SC-8771: The UI executable is now called RedGate.SQLCompare.UI.exe as it was in 11.0
  • SC-8695: Speed up comparison when switching deployment direction
  • SC-8752: The dependencies page in the deployment wizard should now correctly refresh results when different objects are selected

12.0.6.2193 - June 24th, 2016

Fixes

  • SC-8680: The application no longer has graphical errors when used in high DPI modes
  • SC-8706: Source and target databases are correctly labelled in the deployment wizard when reversing deployment direction
  • SC-8758: You are no longer double-prompted for confirmation when saving a deployment script to disk if it will overwrite an existing file.

12.0.5.2129 - June 20th, 2016

Fixes

  • Support for obsolete migrations versions (original and v2) has been removed from the command line.
  • SC-8611: Cancelling the connection dialog window no longer results in mappings being saved

12.0.4.2107 - June 16th, 2016

Fixes

  • SC-8694: Deployment scripts now contain consistent line endings
  • SC-8698: Copying a deployment script to the clipboard now result in the correct line endings
  • SC-8611: Changes to deployment options are now saved when a comparison is not required
  • SC-8728: Make save, copy and search bar visible when loading deployment summary
  • SC-4961: Moved the logging options to the Help menu instead of the system menu

12.0.3.2043 - June 10th, 2016

Fixes

  • SC-8686: Performance improvements for dependencies in the deployment wizard
  • SC-8717: More fixes for SQL Source Control detection where the list of installed applications is problematic
  • SDC-2140: The unmapped objects section of the mappings UI is now expanded by default
  • SC-8715: Improving font consistency: consolidating on Segoe UI
  • SC-8721: SSMS 2016 has been added to the list of possible external editors

12.0.2.2016 - June 9th, 2016

Fixes

  • SC-8610: 'Save project before closing' dialog will no longer prompt for a filename if one is already known
  • SC-8688: SQL Data Compare should no longer interfere with the taskbar auto-hide
  • SC-8692: Text and interactive help fixes for the "Error parsing scripts" dialog
  • SC-8693: SQL Data Compare should now correctly update the selected sql editor when changed from the deployment wizard
  • SC-8655: Use latest icon for SQL Source Control
  • SC-8684: Make SQL Source Control detection more robust when used as a data source
  • Some high-DPI improvements for the differences and filter UIs

12.0.1.1977 - June 6th, 2016

Fixes

  • Minor tweaks to interactive help and database refresh buttons
  • More validation and remote folder browser for backup options in the deployment wizard

12.0.1 - June 3rd, 2016

This is a beta release of SQL Compare 12, which brings a major UI refresh alongside support for major SQL Server 2016 features.


Didn't find what you were looking for?