sqldbtools | SQLDBDiff for SQL Server Version 2005 to SQL 2019, SQL Azure, and SQL on Linux
SQLDBDiff for SQL Server Version 2005 to SQL 2019, SQL Azure, and SQL on Linux
SQLDBDiff is a powerful and easy-to-use tool that compares the schema and the data of your SQL Server databases. SQLDBDiff is an intuitive tool that allows you to: Ø Compare the schema and the data of SQL Server databases, the following SQL 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; CHECK Constraints; Default Constraints; UDDT; DDL Triggers; Synonyms; XML Schema; Permissions; User and Roles; Database properties; SQL Server properties. Ø Generate schema synchronization scripts. Ø Generate a schema difference report. Ø Search for 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 an XML file and avoid manual input. Ø Compare database 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. SQLDBDiffConsole.exe is the console version of SQLDBDiff, the line command has the following syntax: SQLDBDiffConsole ServerName1 DBName1 User1 Password1 AuthWin1 ServerName2 DBName2 User2 Password2 AuthWin2 [OutputFile.txt] SQLDBDiff Freeware version is completely free without any evaluation period, this is my small contribution to SQL Server community. By Ordering the SQLDBDiff Shareware version, you'll get access to more advanced features, free upcoming updates, and technical support by e-mail.
SQLDBDiff for SQL Server Version 2005 to SQL 2019, SQL Azure, and SQL on Linux | sqldbtools
SQLDBDiff is a powerful and easy-to-use tool that compares the schema and the data of your SQL Server databases. SQLDBDiff is an intuitive tool that allows you to: Ø Compare the schema and the data of SQL Server databases, the following SQL 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; CHECK Constraints; Default Constraints; UDDT; DDL Triggers; Synonyms; XML Schema; Permissions; User and Roles; Database properties; SQL Server properties. Ø Generate schema synchronization scripts. Ø Generate a schema difference report. Ø Search for 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 an XML file and avoid manual input. Ø Compare database 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. SQLDBDiffConsole.exe is the console version of SQLDBDiff, the line command has the following syntax: SQLDBDiffConsole ServerName1 DBName1 User1 Password1 AuthWin1 ServerName2 DBName2 User2 Password2 AuthWin2 [OutputFile.txt] SQLDBDiff Freeware version is completely free without any evaluation period, this is my small contribution to SQL Server community. By Ordering the SQLDBDiff Shareware version, you'll get access to more advanced features, free upcoming updates, and technical support by e-mail.