Dear friends,

I am a newbie, I just know about Hibernate. so would anyone tell me if I can use Hibernate to translate database from oracle to mysql.

I have a little homework, translating database from oracle to mysql. there is no big object (BLOB,CLOB) in the oracle database. so in my opinion, first, I should get the oracle DDL, and then translate this oracle DDL to mysql DDL, and then creating mysql database according to this DDL. the last step is to translate data from oracle database table to mysql database table.

I am afraid it will cost me a long time to learn how to use Hibernate, but at last I found I can't finish this conversion using Hibernate, so would anyone tell me if Hibernate can do this job or part of this job? for example, if Hibernate can translate oracle DDL to mysql DDL? if you can give me some little detail information, I will great appreciate!

any hint will be great appreciated!

Sammy

Please stop crossposting the forums

Hi!

Well: I think you can do that.


You will need to create Java objects to map to each one of your Oracle tables and with their relationships. Hibernate has an ant task (cant rememeber the exact name) and theres also this class you might be interested in: http://www.hibernate.org/hib_docs/api/net/sf/hibernate/tool/hbm2ddl/SchemaExport.html.

the key step to go from DB to DB is to change the DB dialect in you hibernate configuration file.

After changing it to MYSQL you should be able to have you DB shema in the appropiate DB dialect.

Hope it helps.