Import a MySQL database into the built in HSQL database

0
Hi everybody, I was wondering about something. The application I'm currently working on run on an external database (MySql, Ubuntu server). This is fine, although performance wise, things could be snappier. My thought was: is it possible to import the SQL dump file, created with SQL Workbench (including the create schema command) into the local HSQL database? I'm sorry if this question has been answered in the past, but I couldn't find a thread about this specific case. Regards, Bart van den Heuvel
asked
1 answers
1

select your current db as buildin db,  then config the following in Custom Settings 

  • SourceDatabaseType (HSQLDB, MYSQL, ORACLE, POSTGRESQL, SQLSERVER)
  • SourceDatabaseHost
  • SourceDatabaseName
  • SourceDatabaseUserName
  • SourceDatabasePassword

 

Refer https://docs.mendix.com/howto/tips/migrating-your-mendix-database

answered