How can i change existing hsqldb to mysqlDB connection

Support
#1

Hi there… would like to know how can i changed exisitng HSQLDB tables to a new mysql DB new IP

regards

#2

Hi,
For your project to be able to use mysql database, you would need to generate database scripts for this DBMS type.

You need to switch Database type to MySQL in the Main Data Store Properties dialog.
Then run Generate Database Scripts - to get database init and update scripts for MySQL.

If you want to transfer data to the new database, you will need to do a SQL backup of the HSQLDB database data using any available tool.

#3

@albudarov Thank you very much…i get the picture