SQL Compare 12.4

Now allows you to compare and deploy temporal tables in Microsoft SQL Server 2016.
June 14, 2017
New Version

Features

  • Summary view of detailed differences - New summary view, which lists the semantic differences between two tables now makes it easier to understand why two objects are different.
    This will help people in situations where the SQL diff isn't representative of the differences between two objects, for example:
    • When comparing tables without the "force column order" option.
    • When comparing different database versions so a constraint is inlined on one side and not the other.
    • When ignoring names of constraints, indexes etc.
  • Summary View - Increased default text size, removed some extra whitespace around the top row of the results and added scrollbars to make the summary view easier to use. The summary view tab will also now stay selected when switching between different objects in the comparison.
  • The authentication type for databases (Windows/SQL Server) is now specified as a dropdown. This allows more authentication types to be added in the future.
  • Now accepts the 'CREATE OR ALTER' syntax introduced in SQL Server 2016 SP1.

Fixes

  • SC-9475: Improved interactions around the database dropdown in the Edit Project dialog: in particular, hitting backspace will no longer clear the database name entirely.
  • SC-9437: Fixed a bug which could cause some rows in the My Projects dialog to not render correctly when there were some invalid project files in the displayed folder
  • SC-9457: SQL Compare now automatically applies the default filter (Filter.scpf) when registering from scripts folders or source control.
  • Drop and recreate PERSISTED computed columns when changes are found, rather than rebuilding their table.
  • SC-9455: SQL Compare now produces the correct existence check when renaming a table and moving it between schemas.
  • SC-9403: SQL Compare no longer leaves duplicate NOCHECK statements when deploying to scripts folders
  • SC-9404: Fixed a bug which prevented the saved sort order in the My Projects dialog from being applied correctly
  • SC-9456: Fixed some high-DPI display issues in the deployment wizard 'Deployment method' settings that occurred when the windows UI scale was set to 250% or greater
  • SC-9439: The "Edit selected file" button on the "Error parsing scripts" dialog will now correctly launch the selected editor
  • SC-9271: When an error occurs updating or dropping an extended property the current transaction will now be rolled back
  • SC-9429: When rebuilding a temporal table, SQL Compare no longer scripts out the HIDDEN property or default constraints on the new history table.
  • SC-9443: SQL Compare now correctly scripts out DATA_COMPRESSION on temporal and memory-optimized tables
  • SC-9476: SQL Compare now handles index drops correctly while disabling SYSTEM_VERISONING.
  • SC-9474: Fixed some high-DPI display issues in the deployment wizard title bar
  • SC-9441: SQL Compare now accepts SET syntax where a property on a CLR user-defined type is being set
  • SC-9440: SQL Compare can now register multiple XML indexes on a single table with several selective XML indexes per index
SQL Compare 12.4
SQL Compare summary view of detailed differences.

SQL Compare

Compares and synchronizes SQL Server database schemas.

Get Quote Buy Now

Got a Question?

Live Chat with our Redgate Software licensing specialists now.