Data Compare for SQL Server Features:

• A simple and intuitive interface, combined with a context-sensitive ribbon, provides easy access to all functions and operations.
• A carefully designed workspace stores data sources, credentials and other settings in one central place.
• Comparison sessions, saved automatically in the workspace, allow you to rerun the most frequent comparisons with just one click.
• Whether you compare a few rows or millions of them, Data Compare will handle any data size with ease.
• Safe script execution, combined with variable batch size and transaction size, allows for an efficient and reliable data synchronization.
• Color-coding data changes makes them easy to identify.
• Compare SQL Server databases, all editions from 2000 to 2019, and the latest SQL Azure Databases.
• Use traditional SQL Server and Windows Authentication, or Azure Authentication with all your databases.
• You can use database primary keys, constraints and indexes to map data rows with each other, or create custom keys in Data Compare when a suitable index doesn't exist.
• You can map tables and views in an instant, using the default rules, or create custom rules and map them in any way you like.
• Compare the whole data or just portion of it by specifying where clauses.
• Use data options to control most of comparison features.
• Use Data Compare to compare, script and synchronize your databases, generate differences reports, all interactively in a simple and intuitive interface.
• Use the Data Compare Command Line to perform all the tasks the user-interface does and run them in batch files.
• Use the Data Compare Command Line Wizard to manage the config files of the command line utility.