Question

Converting built-in database data into SQL, PostgreSQL or Oracle

11

Currently I am working on a demo project and make use of a built-in database. The project is getting serious and I've put lots of data into the built-in database. Is it possible to convert my data into a SQL server, PostgreSQL or Oracle database?

asked 2009-08-03

Fedor Klinkenberg

6 answers

6

And the other way around? Is it possible to convert a Postgres or Oracle database into a HSQL database?

answered 2009-08-12

Jornt Moerland

4

It would be really nice to have some sort of export/import function for data which does not rely on a specific dbms implementation or it's custom import/export format which cannot be reused for other rdbms systems! A complete description of the database structure is available in the metamodel, which is used by the Mendix server already to manage the database structure. So a dump only needs to contain the data objects and associations between objects.

This way you won't need a full mesh of options to convert between all possible db-systems.

answered 2009-08-03

Hans van Kranenburg

3

@Jornt I think you can also use the HSQL Transfer tool for that. See the documentation of this tool for more information. I have no experience with using it, so more info is welcome!

answered 2009-08-13

Johan den Haan

1

I am trying to do this exact thing now but I have found that the link for the HSQL Transfer tool provided in this thread is broken... Anyone have any ideas where I can find it now?

answered 2012-04-11

Johan Griesel

1

I came across this post trying to achieve this myself. In the current versions this is possible by following these instructions: https://docs.mendix.com/howtogeneral/tips/migrating-your-mendix-database
I was able to convert my built-in database using the following settings under the custom tab:

SourceDatabaseHost: http://localhost:8080/
SourceDatabaseName: default
SourceDatabaseType: HSQLDB

Use the database tab to configure your target database.

answered 2018-03-09

Jeroen Odink

Johan den Haan · Accepted Answer · 2009-08-03

For Oracle you can use the Oracle Data Integrator to import HSQL databases (the format of the Mendix Runtime built-in database). See this full reference (the chapter on Hypersonic SQL).

An easier option for non-Oracle experts is the HSQL Transfer tool. This tool can also be used to convert HSQL data to PostgreSQL. See the documentation of this tool for more information. I have no experience with using it, so more info is welcome!