Released: Mar 27, 2017

12.2 での更新項目

機能

• SQL Compare now supports temporal tables on SQL Server 2016.
  • Include temporal tables when deploying changes and comparing differences to your SQL Server databases.
  • See what’s changed in your current table, plus what will be added to the history table.
  • When you are ready to deploy, the script will include the expanded temporal table.
• New warning message lets you know if you are deploying to an older version of SQL Server that doesn’t support temporal tables.
• The My Projects dialog will now remember the previous sort ordering.
• SQL Compare now has an IgnorePerformanceIndexes option to ignore all indexes except primary keys and unique constraints.

不具合の修正

• SC-9208: When loading snapshots, the project's case sensitivity option is now used (rather than the one stored in the snapshot)
• SC-9349: When a deployment adds GENERATED ALWAYS columns to a table, PERIOD FOR SYSTEM_TIME is now set on the table too
• SC-9368: log messages containing curly braces (e.g. if SQL objects have curly braces in their name) no longer cause FormatException to be thrown
• SC-9271: Errors thrown by sp_addextendedproperty are now handled correctly in deployment scripts
• SC-3932: Interactive HTML Reports now escape forward slashes in object names and descriptions
• SC-9204: Filenames are no longer truncated in the deployment wizard when updating a scripts folder
• SC-8944: Improved the title bars of various dialogs in high DPI mode
• SC-9177: Preserve changes to column widths in the My Projects dialog
• SC-9207: Fixed a bug where the end of a temporal SELECT statement would disappear from a textual object definition
• SC-9274: Roles can now contain roles having the same name as a user
• SC-9265: Fix an issue that the Deploy button could be incorrectly enabled or disabled
• SC-9178: Made the Create Database dialog more responsive