
SQL Compare makes it easy to compare and deploy SQL Server database schemas. It can help you compare small or large database schemas, including Temporal Tables, with advanced filtering of database objects. You can also build sophisticated comparison rules to migrate individual schema differences. You can run deployments directly from the UI or command line, save deployment scripts for later use, or automate your deployments using SQL Change Automation.
v13.8 [Jan 19, 2020]
Fixes:
- SC-10625 - CONCAT_WS is now recognised as a system function on SQL Server 2017 and above.
- SC-10644 - The 'drop and create instead of alter' option has been renamed 'use drop and create for rerunnable scripts' and had the 'drop and create instead of create' functionality restored. It still only works on some object types, which are listed in the option description.
- SC-10641 - text objects (e.g. stored procedures) that reference system queues no longer cause a crash in dependency processing.
- SC-10630 - WITH CHANGE_TRACKING_CONTEXT with a literal parameter (as opposed to a variable) no longer causes a parsing error when registering from a scripts folder.