SQL Compare - SQL Compare

  1. SQL Compare 9.0 now supports SQL Azure databases

    Release Notes: Updates in 9.0 SQL Compare 9.0 now supports SQL Azure databases. Various bug fixes ...

  2. SQL Compare v15.3.5.25572

    Release Notes: SQL Compare no longer locks the selective_xml_index_paths catalog view during registration. 0 ...

  3. About SQL Compare

    About SQL Compare

    Description: Compares and synchronizes SQL Server database schemas. SQL Compare is a tool for comparing and synchronizing SQL Server database structures. It is used by over 150,000 database administrators, ... developers and testers. SQL Compare automates the process of distributing database changes made on a local database to testing, staging or live databases on remote servers. SQL Compare compares ... scripting errors Full support for SQL Server SQL Compare is an industry-standard tool for comparing and synchronizing SQL Server database schemas. It is used by over 150,000 developers, DBAs and test ...

  4. SQL Compare v15.3.4.25528

    Release Notes: to the server name are now used again when comparing two SQL Source Control revisions from the SQL Compare command line. 0 ... Fixed issue when connecting to Azure SQL instance where an error occurred related to the loading of assembly Microsoft.IdentityModel.Abstractions. Additional connection string properties added ...

  5. SQL Compare v15.2.1.24235

    Release Notes: Compatibility with SQL Data Compare 15.2.1.24235. 0 ...

  6. SQL Compare v15.2.4.24551

    Release Notes: resolution speed for SQL Compare GUI and CLI. Improved deploy summary tab speed. Improved snapshot registration speed when triggers are present. 0 ...

  7. SQL Compare v15.2.5.24669

    Release Notes: registration. Added support for APPROX_PERCENTILE_CONT and APPROX_PERCENTILE_DISC functions in Microsoft SQL Server 2022. Fixed a memory leak in the SQL Compare UI, noticeable when refreshing large comparisons. ...

  8. SQL Compare v15.3.3.25341

    Release Notes: Fixed scripts folder parsing of "window" when not used as a keyword. 0 ...

  9. SQL Compare v15.3.2.25249

    Release Notes: Ensured rendering of the pre- and post-scripts in the summary view does not break the UI. 0 ...

  10. SQL Compare v15.3.1.25177

    Release Notes: Added support for the following TRIM function optional arguments: LEADING, TRAILING and BOTH. Added support for using sp_unbindefault against a table to override the binding of a default on a column's user-defined type. Fixed a crash when permissions are added to columns of a file table. Fixed ...

  11. SQL Compare v15.3.0.25068

    Release Notes: Added read-only support for Flyway projects, allowing you perform comparisons with Flyway on the left. Prevent scripting 'Online = On' for indexes which are part of a UDT Table. Updates in v15.3.x 1 ...

  12. SQL Compare v15.2.7.24880

    Release Notes: Fixed a caching bug during script folder registration. 0 ...

  13. SQL Compare v15.2.6.24771

    Release Notes: Made changes to the UI to always open 'Save As' dialog window when saving filters. 0 ...

  14. SQL Compare v15.2.3.24503

    Release Notes: Added support for the 'JSON_OBJECT' function introduced in Microsoft SQL Server 2022. 0 ...

  15. SQL Compare v15.2.2.24260

    Release Notes: Added support for the JSON_OBJECT SQL function introduced in Microsoft SQL Server 2022. 0 ...

  16. SQL Compare v15.2.0.24040

    Release Notes: Table mapping screens have been made more responsive by significantly reducing the number of times they reprocess saved data. Note that the project Save button no longer grays out when there are no unsaved changes. Updates in v15.2.x 1 ...

  17. SQL Compare v15.1.x

    Release Notes: columnstore index. Fixed an issue encountered when SQL Server system defined CLR types are prefixed with "[sys].". v15.1.0.23826 Updated Sep 6, 2023 Features Added a link to licensing restrictions ...

  18. SQL Compare 14.8.x

    Release Notes: 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. ... for untrusted certificates. v14.8.0.21190 Updated Jun 14, 2022 Features SQL Compare now encrypts connections to Microsoft SQL Server by default. Previously, connections would have been encrypted according ... Now encrypts connections to SQL Server by default. v14.8.5.21499 Updated Jul 26, 2022 Features Added support for T-SQL undocumented virtual column '%%physloc%%'. Fixes Fixed deployment ...

  19. SQL Compare v14.10.x

    Release Notes: SQL Compare will no longer install the Microsoft Active Directory Authentication Library (ADAL) as a pre-requisite as it is superseded by MSAL. v14.10.5.22107 Updated Oct 18, 2022 Fixes Prevented ... Updated Sep 28, 2022 Fixes Prevented SQL Compare from creating foreign keys that already exist in target. v14.10.1.21845 Updated Sep 21, 2022 Fixes SQL Snapper- Error populating database list when ... TrustServerCertificate is required to be true has been fixed. Fixed command line bug where an invalid filter file would cause SQL Compare to log the error but not stop. v14.10.0.21773 Updated Sep 13, 2022 Features Beta ...

  20. SQL Compare v14.9.x

    Release Notes: of the Failover Partner parameter. v14.9.0.21563 Updated Aug 10, 2022 Fixes SQL Compare will now only rebuild a table when the filegroup differs just by casing if the "Use case-sensitive object ...