I recently overheard a conversation amongst my developers about schema drift. i.e. One schema on one server not matching the schema on another for the same database, when they should be the same.

This often comes about when people start making changes to databases directly without going through sourcecontrol and automated db schema change deployments.

It reminded me that a while back I created a simple C# Console Application that compares the schemas of a database between two servers and emails the diff to a recipeint.

It's pretty crude, but does the trick.

Anyway, it's here on my GitHub called CompareSchemas