Migrating from HSQLDB to MySQL
i am " Migrating from HSQLDB to MySQL " and will update the forum how the process going on.
if i face issue anywhere, will let you know as-well and ask for the help cheers |
Sounds like someone let a development system get turned out to production before they were ready too!! ;)
I've had great success in this situation using the Mysql Workbench which does migrations. Give it a try. https://www.mysql.com/products/workbench/ |
What was your decision made on?
I continually examine mySQL and personally I wouldn't migrate to it unless there was a very special set of circumstances. We chose PostgreSQL instead (in fact we replaced Oracle with it and have never regretted it) for far better ACID compliance.
May I ask your decision points, abhijeetdutta, for moving from HSQLDB and why did you chose mySQL? |
I did it successfully along with getting smtp mail server cofigured :)
|
Hello,
I am really sorry for my late reply, as i was suffering from cough and cold. Regarding my post, i did it successfully. @ szboardstretcher- Thanks for your recommendation, i also followed same and it works for me. Below url help me alot https://community.igniterealtime.org...20mysql_en.pdf https://confluence.atlassian.com/dis...SQLDB+to+MySQL You need install some jar files and other stuffs to make it run successfully Thanks |
Hello heytimc
regarding your question " for moving from HSQLDB and why did you chose mySQL? ", reason, i am using openfire HSQLDB as backend. we are planning to hookup this box to AD server and HSQLDB not responding as our expectations initially. This the reason, i migrated my servers to mySql. Thanks |
But why?
I meant more specifically what criteria did you use to select mySQL? There are many databases to choose from - what business match did the features of mySQL make that made you choose it over others like PostgreSQL?
|
All times are GMT -5. The time now is 05:46 AM. |