SQL Compare 新版本發表

Released: Dec 20, 2022

v15.0.x 中的更新

v15.0.7.23280

Updated Mar 14, 2023

Fixes

  • "Encrypt" and "Trust server certificate" server connection checkbox values are now loaded with server connection details from server dropdown.

v15.0.6.23274

Updated Mar 7, 2023

Fixes

  • Warn that non-primary filestream filegroups of tables will need to be created manually.

v15.0.5.23181

Updated Feb 21, 2023

Fixes

  • Fixed issue with table mappings not appearing when connecting through Azure MFA to a managed instance.

v15.0.4.23133

Updated Feb 14, 2023

Fixes...

Released: Sep 13, 2022

v14.10.x 中的更新

v14.10.9.22680

Updated Dec 8, 2022

Fixes

  • Adding 'NOT NULL' to a temporal table column will now update values in the history table to the default value and display a warning.
  • Primary keys are now correctly dropped before being replaced when using system versioning.

v14.10.8.22508

Updated Nov 24, 2022

Features

  • Added support for long file paths in Microsoft Windows when enabled in the Windows registry.

Fixes

  • SCHEMABINDING is correctly dropped on functions that are created WITH EXECUTE AS...

Released: Aug 10, 2022

v14.9.x 中的更新

v14.9.3.21711

Updated Sep 6, 2022

Features

  • Added support for the 'OPTIMIZE_FOR_SEQUENTIAL_KEY' index option.

v14.9.2.21665

Updated Aug 30, 2022

Fixes

  • Fixed an issue in parsing query MATCH syntax from scripts folders.

v14.9.1.21642

Updated Aug 16, 2022

Features

  • Upgraded to Microsoft.Data.SqlClient 5.0.0.

Fixes

  • Fixed an issue where database connections failed due to mishandling of the Failover Partner parameter.

v14.9.0.21563

Updated Aug 10, 2022

Fixes

  • SQL Compare will now only rebuild a table...

Released: Jun 14, 2022

14.8.x 中的更新

v14.8.5.21499

Updated Jul 26, 2022

Features

  • Added support for T-SQL undocumented virtual column '%%physloc%%'.

Fixes

  • Fixed deployment script object existence checks, when source and target have column names that differ only in case.

v14.8.4.21440

Updated Jul 19, 2022

Features

  • Updated compatibility with SQL Data Compare 14.8.4.21440.

v14.8.3.21395

Updated Jul 5, 2022

Fixes

  • Fixed an issue with verifying server certificates when an explicit port number is set.

v14.8.2.21320

Updated Jun...

Released: Mar 16, 2022

14.7.x 中的更新

v14.7.8.21163

Updated Jun 8, 2022

Features

  • Internal library updates.

v14.7.7.21053

Updated May 24, 2022

Features

  • Added the option to use 'CREATE OR ALTER' statements when deploying to servers that support this feature.

Fixes

  • Fixed an issue with recognising the data type of fields that are user defined types, in history tables of temporal tables.

v14.7.6.21017

Updated May 17, 2022

Features

  • Updated compatibility with SQL Data Compare 14.7.6.21017.

v14.7.5.20971

Updated Apr 26, 2022

Fixes

  • Fixed an...

Released: Aug 19, 2021

14.6.x 中的更新

v14.6.20.20708

Updated Mar 1, 2022

Fixes

  • Delimit credential names for external data sources.

v14.6.19.20650

Updated Feb 22, 2022

Fixes

  • Fixed issue which caused data compression settings on partitioned temporal tables to not be read from scripts folders.

v14.6.18.20606

Updated Feb 15, 2022

Fixes

  • Stop rebuilding temporal tables and their history tables due to system named constraint and index name differences when the option "Ignore system named constraint and index names" is used.
  • SQL Compare can...

Released: Mar 4, 2021

14.5.x 中的更新

v14.5.22.19589

Updated Aug 16, 2021

Fixes

  • Fixed broken table renaming technique.

v14.5.21.19562

Updated Aug 9, 2021

Fixes

  • Internal library updated.

v14.5.19.19515

Updated Jul 26, 2021

Features

  • Improved performance when reading from backup files.

v14.5.18.19506

Updated Jul 22, 2021

Fixes

  • Fixed error 'field change calculation failed in TableRebuildChecker' when deploying in certain mapping scenarios.

v14.5.17.19461

Updated Jul 19, 2021

Features

  • Internal library updated.

v14.5.16.19388

Updated Jul...

Released: Aug 24, 2020

14.4.x 中的更新

v14.4.23.18321

Updated Feb 22, 2021

Fixes

  • ZD-245196: Deploying a full text catalog along with its owner will no longer duplicate the CREATE USER statement.
  • SC-10963: The /makescripts option on the command line no longer writes out migration blocks metadata for non-migration blocks databases.

v14.4.22.18256

Updated Feb 15, 2021

Fixes

  • SC-10959: SQL Compare now properly handles temporal tables on partition schemes.

v14.4.21.18202

Updated Feb 8, 2021

Fixes

  • Internal library updates.

Released: Jul 20, 2020

14.3.x 中的更新

14.3.4.16598

Updated Aug 19, 2020

Fixes

  • Fixed "Multi-module assemblies are not supported when loading from memory".

14.3.3.16559

Updated Aug 11, 2020

Fixes

  • Internal library updates.

14.3.2.16501

Updated Jul 30, 2020

Fixes

  • The current highlighted row in the differences grid is deselected (de-highlighted, not unticked.) after a refresh.
  • SC-10890: Azure AD users are now registered on an Azure SQL database.
  • SC-10891: When generating a script for a partition scheme change, an exception is no longer...

Released: Jan 29, 2020

14.2.x 中的更新

14.2.19.16383

Updated Jul 13, 2020

Fixes

  • Internal library updates.

14.2.18.16317

Updated Jul 6, 2020

Fixes

  • SC-10865: Fixed the filter pane behavior when changing All Object Types.

14.2.18.16251

Updated Jun 29, 2020

Fixes

  • SC-10852: Fixed SQL Server version not being read from SSDT/SCA project file.
  • SC-10853: When rebuilding an index, the order of included columns is now respected.
  • ZD160360: Fixed an occasional hang when comparing CLR assemblies.

14.2.17.16188

Updated Jun 23, 2020

Fixes

  • SC-...