I'm a huge fan of the business data connector in Sharepoint
2007. I was thinking about writing a tool that would help to
generate some metadata given a SQL Database... I'm a little
late.. If you are doing any work with the BDC, check out
Database Metadata Generator for the Business Data
Catalog