It created very nice HTML reports showing detailed info about Feature Datasets, Feature Classes, Relationships Classes, Domains etc, even including user info if I remember well.
Since you're running legacy 8.x, you might try and install it and see if you can get it working. Should be of real help in getting a good overview of the Geodatabase's schema.
Marco, Thanks for the comments. But let's not discuss the sensitive data/policies of company. May be my mistake of publishing non-required things here.
Sorry, just couldn't help notice it and it made me smile... I know I can be a bit direct in these issues.
Finally along with the spatial database connection, I could generate the Metadata (Geodatabase schema details, object class, etc.) report using Geodatabase Reporter extension as well. It will really help us in next migration.