Comparison reports generated in SQL Compare now have a modern look and feel providing simpler and clearer reports that focus on the differences between the compared databases, making it easier for you to quickly see what’s changed and share with your team.
New HTML reports
In SQL Compare 13 we have added support for SQL Graph. This new feature in SQL Server 2017 adds graph database capabilities for modeling many-to-many relationships.
This is used extensively by social media platforms such as Facebook and LinkedIn, and other businesses are now looking at how they too can explore them to reveal valuable information about the relationships between customers.
SQL Compare fully supports SQL Graph, and allows you to compare and deploy databases which include both graph and relational tables.
In SQL Compare has supported temporal tables for a while, but in SQL Compare 13 we have improved this support in line with the new feature introduced in SQL Server 2017.
The new functionality includes temporal table history retention policies. SQL Compare now supports customisation on history tables for temporal tables, such as customised indexes.
SQL Compare now supports Azure Active Directory authentication with integrated and password authentication methods. These options are available in the 'Authentication' dropdown in the 'Database' section of the 'Edit project' window. Note that this feature requires .NET 4.6 and adalsql.dll to be installed, click here for more details.
With SQL Compare 13 you now have the option to securely save your login details for databases and servers so they don't need to be re-entered each time.
If you use SQL Monitor you can now connect SQL Compare so that deployments are automatically detected and displayed within your dashboard.
Please note: This feature will require a SQL Toolbelt license.
In SQL Compare 12 we added a brand new way to examine the differences between two objects in your database. In SQL Compare 13 we are continuing to develop this new feature to make your differences even easier to read.
We have added an alternative way of viewing the differences between objects in a database. The new summary view provides a more concise view of the differences between two objects by getting rid of the SQL and showing only the semantic differences between objects in a much more structured way.
In addition to the new summary view, we have also made it easier to see why two tables are different when looking at the SQL difference viewer, so that it always displays the columns in an order that makes it clear exactly what the differences are.
We have also made changes to the colors used to show differences between the left and right hand sides, so that differences in the source database are shown in green and differences in the target database are shown in red.
By moving to this color scheme, commonly used in other diff viewer tools, we have increased visual contrast, making it easier to see at a glance where the differences between the source and target are. The change to the color scheme also makes it clearer that the changes to the source database, in green, will be added, or applied, to the target and those changes to the target database, in red, will be removed, or overwritten. This is in keeping with how most other diff viewer tools use red and green.
To access new features in SQL Compare as soon as they're ready, turn on frequent updates – they're typically released once a week. Learn more
Our roadmap contains details of what is coming next for SQL Compare. Check it out.