SQLDBDiff is a powerful and intuitive tool that compares the schema and the data of SQL Server databases. SQLDBDiff supports SQL Server Version 2012 to 2022, SQL Azure and SQL on Linux.

Click here to download SQLDBDiff

SQLDBDiff key features: 

- Compare the structure of two SQL Server databases

The following objects are supported:

• Tables and columns (with the possibility to respect or not columns order);
• Views (including their indexes and triggers);
• Stored procedures;
• User defined functions;
• Triggers;
• PK and Indexes (with the possibility to include or not statistic indexes);
• Relationships (FK);
• CHECK Constraints;
• Default Constraints;
• User Defined Data Type & User Defined Table Type
• DDL Triggers;
• Synonyms;
• In-Memory table
• System versioning (Temporal type)
• Permissions;
• User and Roles;
• Database properties;
• SQL Server properties.

-       Generate schema synchronization scripts.

-       Generate a schema difference report.

-       Search an object by its name or content (text).

-       Compare many databases to the same master database in one step. With SQLDBDiff you cannot only compare two databases, but many databases to the same master database, you can save the list in XML file and avoid manual input.

-       Compare databases contents With SQLDBDiff you can compare tables even if they have different schemas or the primary key is missing. You can choose grid mode or text mode, in this last case you can:

• Select columns to be compared;
• Define a maximum of rows;
• Add WHERE or ORDER BY clause.

-       Generate data synchronization scripts.

-       Export database schema in flat file so you can import in your version-control software

SQLDBDiff is now supporting SQL Server on Linux (vNext),

Click here for more details

SQLDBDiffConsole.exe is the console version of SQLDBDiff, the line command has the following syntax :

For Windows Authentication:
SQLDBDiffconsole.exe SQLServerSource SourceDatabase NULL NULL Y SQLServerTarget TargetDatabase NULL NULL Y SqlDbDiff.XML CompareResult.txt SyncScript.sql

For SQL Authentication:
SQLDBDiffconsole.exe SQLServerSource SourceDatabase User1 Pwd1 N SQLServerTarget TargetDatabase User2 Pwd2 SqlDbDiff.XML N CompareResult.txt SyncScript.sql
(Replace params values like SQLServerSource, SourceDatabase, User1, Pwd1, etc., with your actual values.)

SQLDBDiff Freeware version is completely free without any evaluation period, this is my small contribution to SQL Server community.

By Ordering SQLDBDiff Shareware version, you'll get access to more advanced features, free upcoming updates and technical support by e-mail

Click here to see some snapshots

Supported versions : SQL Server 2012 to 2022, SQL Azure and SQL on Linux