Released: Oct 15, 2018

13.6 での更新項目

機能

• SQL Compare now supports comparison and deployment of sensitivity classifications
• SQL Data Compare options can now be specified with the /datacompareoptions switch when deploying static data through the SQL Compare command line.

不具合の修正

• SC-10264: User defined types that are dependencies will no longer be deployed if the option to include dependencies is not set.
• The DataFileSet node of the RedGateDatabaseInfo.xml file in a scripts folder has been deprecated and no longer affects static data...

Released: Sep 17, 2018

13.5 での更新項目

機能

• Added support for using SQL Change Automation projects as a data source in SQL Compare.

不具合の修正

• A create index statement with a string literal as a filegroup name will no longer cause a parser error.
• Fixed the sca2 command-line parameter not being recognised.
• SQL Compare no longer explicitly deploys default data spaces.
• SQL Compare command line no longer normalises all line endings to CRLF when adding static data.

Released: Jan 30, 2018

13.1.10 での更新項目

機能

• Handles filegroups defined on a fulltext index.
• Handles user defined and customized history tables for temporal tables, and will store all history tables in scripts folders.
• Integrates the Redgate bulk uninstaller.
• SQL Compare Command Line now runs in 64-bit mode by default.

不具合の修正

• SQL Compare no longer displays a blank warning dialog when asking to overwrite the existing comparison report
• SQL Compare doesn't duplicate index creation on history tables.
• SQL Compare can deploy history tables...

Released: Oct 30, 2017

13.1.x での更新項目

機能

• Improved logging capabilities
• SQL Compare now generates a new style of HTML report, to match the reports produced by other Redgate products.

不具合の修正

• SC-9781: SQL Compare can deploy temporal tables from a scripts folder to a live database.
• SC-8880: Scripts folders can now be in the root of a drive (as long as it is otherwise empty)
• SC-9775: On the command-line, in the absence of a -reporttype switch, SQL Compare now correctly uses the -report switch to infer the report type, based on the report...

Released: Oct 16, 2017

13.0.x での更新項目

機能

• SQL Compare now requires .NET 4.6.1.
• Improved the installer UI for SQL Compare.
• SQL Compare now supports altering SQL Server 2017 graph tables.
• SQL Compare now deploys SQL Server 2017 graph tables declared with AS NODE or AS EDGE.
• SQL Compare now appends a logging statement at the end of the deployment script to log the deployment details to SQL Server Log in order for SQL Monitor to detect the deployment and mark it on the timeline for performance data. Note that this feature is currently in...

Released: May 16, 2017

12.4 での更新項目

機能

• Summary view of detailed differences - New summary view, which lists the semantic differences between two tables now makes it easier to understand why two objects are different.
  This will help people in situations where the SQL diff isn't representative of the differences between two objects, for example:
  • When comparing tables without the "force column order" option.
  • When comparing different database versions so a constraint is inlined on one side and not the other.
  • When ignoring names of...

Released: Mar 27, 2017

12.2 での更新項目

機能

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

Released: Sep 19, 2016

12.0 での更新項目

機能

• New User Interface (UI) - Overhauled UI of SQL Compare aligns with Redgate's new common design guidelines. Improves the underlying codebase and fixes over 200 UI related bugs.
• Parallel registration - When registering from a live database, scripts folder, or a snapshot, SQL Compare will now register both data sources at the same time, rather than waiting for your source to finish before starting on the target. This should speed up the comparison considerably.
• Login based licensing - SQL...

Released: Jul 18, 2016

11.6 での更新項目

機能

• Now accepts the ALTER DATABASE CURRENT syntax.
• Now connects to SQL Server 2016 RTM.
• New product switcher - accessible from the product logo top-left.
• Now deploys migrations created in SQL Source Control 5 Release Candidate.
• Migrations created with the SQL Source Control 5 Beta are no longer supported.

不具合の修正

• SC-8668: SQL Compare no longer generates incorrect creation script for objects using WITH ENCRYPTION option when AS keyword not specified.
• SC-8421: Dependencies now correctly calculated...