A few months ago I wrote a python script that built relation data from a database using only primary key data (all the PKs were GUIDs) to build a mapping of the

A few months ago I wrote a python script that built relation data from a database using only primary key data (all the PKs were GUIDs) to build a mapping of the actual relations from the database. This particular application had grown quite large and no relationships were ever really documented. Then once the relationships were all mapped out, I wrote another Python script to shell out C# classes for all of the tables and their relations so that I had an easy way (data library + basic web forms) to explore the data. All said and done I think it was a shade under a thousand lines and saved me weeks of exploration and hand coding.