SQLDBDiff allow you :
-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;
-CHECK Constraints;
-Default Constraints;
-UDDT;
-DDL Triggers (SQL 2008, 2005);
-Synonyms (SQL 2008, 2005);
-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.
Comments