Have you got two SQL server databases and need to know what changed ? What Tables, Columns, Views, Indexes, Triggers, Stored Procedures, User Defined Functions were added/removed/modified that makes them different ? SQL Diff is the tool.
Currently supporting Microsoft SQL Server 2000, 2005, 2008 (including R2) and the variations of Microsoft SqlExpress.
Compare databases on the same server, different servers, offline snapshots, SQL Server to SqlExpress and vice versa. Compare your development database to your live one to know what scripts to generate to equalize the two. Compare previous versions of offline database schemas to find out when a change was made that introduced bugs …etc.
With SQL Diff you can connect to both local and remote SQL Servers or SqlExpress versions of Microsoft SQL databases and compare the tables, stored procedures, views ..etc. SQL Diff will generate a report detailing what items needs scripts generated for them (you can use the various versions of SQL Management Studio or other management interfaces to generate your scripts).
you can generate an offline snapshot of your database schema to compare at another time. This is especially useful if you dont have a direct network connection between the two databases you need to compare. These snapshots are easily checked into a source control tree so you can compare the database schema at various points in your development cycle or milestones. Often when bugs are introduced you have to go backwards in time to find out where the issue was introduced. regular offline snapshots will help in this.
For items such as store procedures where a text line by line Diff is useful, a standard text Diff window for comparing the two side by side is provided with color coding to show whats been added, deleted and modified. Just right click on an entry with the “changed icon” and select “Compare differences”
If you can’t directly connect to both your databases at the same time, the offline snapshot feature works well. You can generate an offline snapshot of any database, saved as a text file which can then be compared either to another offline snapshot, or directly to a database. If you keep the offline snapshots checked into your source tree, you can easily see what has been changed over time with each new changeset. SQL Diff can compare live to live, offline to offline, or live to offline.
Navigating through the various objects and changes in a database is easily done with the F3 key, or the menu choice for left and right servers.
You can generate a simple report listing all the objects that need changes to bring them into line with the other server. This is done on a per-server basis, so you can see the changes that would turn the left server into the right server, or the changes that would make the right server into the left server. This is particularly useful when unexpected changes have crept into the schema.
Various view options can be synchronised to make navigation easier. As you move around in one tree, the matching entry in the other tree is autiomatically selected showing its properties in the window at the bottom.
Limited time – introductory offer: Only $30 (normally $50)
See here for installation notes.
* caveat: The current version of Sql Diff does not compare the changes made to global database settings such as collation or Ansi NULLs. Sql Diff does not currently read SQL schema files directly, although this is expected in a future version. Please use the contact form and drop me a note and I’ll let you know when its available.
**caveat: Sql Diff does not support other database formats such as MySql or DB2, although this is also planned for a future release. Please use the contact form and drop me a note and I’ll let you know when its available.
*** How do I know if I have a 32 bit or a 64 bit system ? The easiest is to use my computer to navigate to the root of your hard drive. If you have both a “program files” and a “Program files (x86)” folder you have 64 bit. if you only have one, then you have 32 bit. Alternatively, Start->Control Panel->System And Security->System. If you look at the system type, it will say 32 bit or 64 bit system.