Thanks a lot Marco & Vince.
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.
Warm regards,
Sandip