
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.
v14.5 [Apr 16, 2021]
Fixes
- ZD-250030: Turning off system versioning on a table that is consumed by a security policy no longer results in an incorrect deployment script
- ZD-251196: Fixed a bug in deployment scripts using CURRENT_USER
- ZD-251135: STATISTICS_NORECOMPUTE=ON is no longer scripted out for columnstore indexes; instead sp.autostats is invoked