DiffSchema is a small program that detects differences between the schemas of 2 MS SQL databases. It's very easy to use but it's also pretty powerful and you can do quite a lot of things with it. DiffSchema is free, open source software. You are welcome to use it or modify it however you wish (let us know if you improve it!). You can download DiffSchema from sourceforge.
DiffSchema works by comparing any 2 SQL databases and detects any differences between them. DiffSchema can detect differences between tables, views, stored procedures and functions. You can setup multiple pairs of databases with different rules. A typical scenario may be to ensure the structure of the databases are identical but only check the rowcounts on a subset of tables. To do this you would add 2 DiffSchema configurations .
Comments