LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Server (https://www.linuxquestions.org/questions/linux-server-73/)
-   -   Migrating from HSQLDB to MySQL (https://www.linuxquestions.org/questions/linux-server-73/migrating-from-hsqldb-to-mysql-4175505122/)

abhijeetdutta 05-15-2014 03:05 PM

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

szboardstretcher 05-15-2014 03:32 PM

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/

heytimc 05-16-2014 02:37 AM

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?

raje 05-16-2014 12:31 PM

I did it successfully along with getting smtp mail server cofigured :)

abhijeetdutta 05-19-2014 08:39 AM

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

abhijeetdutta 05-19-2014 08:45 AM

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

heytimc 05-19-2014 09:14 AM

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.