Hi,
My requirement is to compare two database schema for changes in structure as well as data. So i should have two databases which i hereby refer to as source and target.

Now the problem is that I have hibernate mapping files as input for both source and target databases.

My question is, whether it is possible to compare or fetch schema details when only the mapping information is given. I understand by reading the hibernate docs that the mapping files are Java centric and is not based on database declaration.

Can there be a solution to this?

I've tried out by comparing the meta-data by direct JDBC calls, But i am forced to opt the first approach.

Please reply.
Thanks in advance.