Hi ,

I want to migrate data from one DB to other and for this I'm planning to use Hibernate in which case I can map the data in tables in DB1 to objects & store this objects into DB2.

The reason for using such an option is that I'm not willing to reveal the schema of one DB to other.

Please could some Hibernate guru tell me if this is the right approach or suggest something.

It would be a real help.


Thanks!

Its one way - sure. It might be your best way but then again it might not be - we do not understand your circumstances. You could have a quick look around at ETL tools around - there are a few that work quite well.

Thanks David for your reply!!

To make my question clearer, here is what I'm looking for:

We have a desktop application where in there's lots of data in around 3000 dBs( sybase desktop db).
Now we are planning to migrate this Desktop application to web application.So want to migrate all the data in these (3000) sybase dBs to some vendor specific web dB.

And that's why we dont want to reveal schema of sybase dB to the vendor.But just provide data to the vendor without revealing the schema.

So I was thinking if Hibernate would be the best option.
Is there any better approach for this type of migration.


Please help.