SQLDBDiff is a powerful and easy to use tool that :
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);
User defined functions;
PK and Indexes (with the possibility to include or not statistic indexes);
DDL Triggers (SQL 2008 and 2005);
Synonyms (SQL 2008 and 2005);
XML Schema (SQL 2008 and 2005);
User and Roles;
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.
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 SQLDBDiff Shareware version , you’ll get access to more advanced features, free upcoming updates and technical support by e-mail.
For more information please visit : web site.
Unit Price: EUR 59.04
Total: EUR 59.04
plus 19% sales tax/VAT to EUR 59.04: EUR 11.22
Delivery: License key
Language: English / French
Platform: , Microsoft Windows
General requirements: Microsoft .Net Framework 2.0
Tags: SQL Server, SQL Server databases, SQL Server properties, SQL Server community, Generate schema synchronization, SQL Azure, schema difference report, synchronization scripts, Generate data synchronization, SQLDBDiff Freeware version, SQLDBDiff Shareware version, User2 Password2 AuthWin2, master database, Microsoft .Net Framework, Compare many databases, Compare databases, DDL Triggers, EUR, statistic indexes, XML Schema, following objects, Default Constraints, Stored procedures, Database properties, different schemas, XML file, text mode, grid mode, primary key, manual input, console version, Microsoft Windows, SQLDBDiffConsole ServerName1, evaluation period, General requirements, Unit Price, small contribution, technical support, web site, line command, following syntax, sales tax/VAT, information please visit, Oslash, columns, possibility, tables, Permissions, clause, PK