SQL Compare 12.2

Permet de comparer et de déployer des tables temporelles dans Microsoft SQL Server 2016.
Mars 28, 2017
Nouvelle Version

Fonctionnalités

  • 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.

Correctifs

  • 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
Compare temporal tables in Microsoft SQL Server 2016.

SQL Compare

Comparez et synchronisez les schémas de bases de données SQL Server.

Vous avez une question ?

Discutez en direct avec l'un de nos spécialiste des licences Redgate Software .