[jboss-user] [EJB 3.0] - EJB 3.0, Database migration tool

[runar.solberg@adactus.no]

Hi,

I have a system which is using JBoss an hibernate, with EJB.3.0. My system can be deployed using diffent database systems, e.g. PostgreSQL, Hypersonic, Oracle, MySql, as I have no database specific code. We use general EJB QL for our queries. So lets say I deploy my application using Mysql. The datamodel is generated in the Mysql DB and everything works fine. Now, after a while I whish to change to say Hypersonic DB or PostgreSQL. I want to keep the allready persisted data. But I have a problem as e.g. enums are translated to different datatypes for the different DBMS. I cannot simply e.g. do an SQL export / import between the different DBMSs, as the O/R mappings will fail. So what I would need is some way to migrate the data through the EJB context, first populating the existing enitities, and do a new O/R mapping to the new DBMS. It there such a tool available? Surely other people must have faced this issue before me?

Thanks for your response.

-R  

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4088297#4088297

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4088297