xSQL Software Schema Compare for SQL Serverがリリースされました

xSQL Software Schema Compare for SQL Server allows for comparing and synchronizing any two Microsoft SQL Server or SQL Azure database schemas, generating a safe, target compliant synchronization script, and executing the sync script on the target database. The included schema snapshot capability, and the command line utility make this an ideal tool for automating the management of the database schema changes.

New in v11.1.0.0

• Adds support for Microsoft Azure Active Directory Authentication for SQL Server, the comparison tools now support:
  • Azure Active Directory Integrated Authentication.
  • Azure Active Directory Password Authentication.
• New Schema Differences Reports.
• Support for graph tables and edge constraints.
• New schema options for CLR assemblies on SQL Server 2017.
• Support for Azure External Users: Schema compare now supports external users on Azure SQL Databases. This includes both the external users and the external groups.
• Check constraint mappings: Previous versions of the schema compare mapped the check constraints by name or by the column on which the constraint is defined. This feature however was supported for check constraints on a single column. Version 11 removes this limitation and supports the column-mapping for composite check constraints on multiple columns.
• Unique constraint mappings: Schema compare now supports mapping of unique constraints based on their columns, in addition to mapping by name. Unique constraints mapped by columns do not trigger a schema difference if their name is different.