Visuall comparison

DBTYP.NET Studio gives users ability to easily observe and quickly locate all differences visually. Full color marked differences database browser tree enables users to inspect differences between tables, views, stored procedures and functions and to drill down to specific column, constraint or index difference. Each column contains it's full description including data type, data length, identity definition, default value.

Working with DBTYP.NET Studio and it's most intuitive user interface on the market, there is no need to inspect a tons of SQL script anymore to identify changes like in other comparison solutions. After you have succesfully compared your databases, click on the root nodes (tables, views, stored procedures, functions) and you immediatelly see what has been modified, added or deleted from database.

Items in blue are modified items, in red are newly created object in the database and black items are the same on both databases.

As an example we pick a screen shot bellow. You can easily identify following:
Table [ab_abstract_category] has the same structure in both databases.
Table [Categories] is modified and changes are following: column [CategoryID] has been shown in blue and declared in the left database as Identity(1, 1) column. Right database contains two additional columns [MissingCol1], [MissingCol2] shown in red here. Also left database contains one nonclustered index more [CategoryName] on column [CategoryName] than the right database and is printed in red.

You can double click on any object to view full create script differences for it and it's comparison pair.