Friday, January 7, 2011
Schema Sleuth Finds Related Data Automatically
Just wrote Schema Sleuth to help "spider" a database or schema to find all related data, and to output it to the console as text-based representations of partial tables or SQL inserts. In my case, I wanted everything related to a User ID and its related data, but it can find almost any subset of related data easily. It's written to be called as a Ruby command-line/CLI script in *nix. Tested with OS X against a few Oracle schemas.