Hi, We have a grails-groovy based application and initially we developed for MySQL as the database. We now want to extend support for Oracle and MSSQL. The will need changes to some of the queries which are not written in HQL. What are my options here? I think since we are already using Hibernate that would be the way to go. By for many queries written for MySQL only, we will need to create new domain classes to map it to backend tables. I am fine with that if that is a solution which will make queries totally independent of backend database technology we use. Regards, Priyank
Try Toad data modeler,
http://www.quest.com/toad-data-modeler/ I believe that there is a free version, but the full version is well worth the cost. You should be able to reverse engineer your MySQL database, then automatically create MSSQL and Oracle SQL scripts to create the database and objects.