Database concordance generator – CodeSmith Style!

Thanks to one of my favorite attendees, Oren Ellenbogen, who is a CodeSmith guru, for providing a CodeSmith solution to my SQL Server concordance generator that I demonstrated at SQL Week in Israel.

A “concordance generator” is something I came up with, which scans through all of the columns, in all of the tables, in a database, and looks for anomalies, such as two columns with the same name, but with different data types, sizes, nullability, etc. It’s good for people who like their database structures just so — like Monk!