Support finally resolved the issue. Overall the documentation is OK but the missing key is this:
I have done this several times between PostgreSQL and MS SQL, but never used the internal HSQLDB as starter db type. Typically the input is of a well known (not HSQLDB) type like Oracle or MS and it always needs a proper IP address + port number on which the db is accessible. HSQLDB are flat files with SQL statements. My advice is to ask support about these settings as this is quite a corner case scenario.I have doubts whether this is possible in the first place for HSQLDB specifically
Anyone that knows how this should work from PostgreSQL to built-in. The documentation says it is possible, but after I filled in the Source parameters, the app just starts without importing anything (or throwing an error).
EDIT: Turns out I had to remove the database from the deployment folder. It works fine now!
Hello,
I have a second question on that topic:
I have a mendix app (Testversion) running locally and I deployd it to private cloud. The cloud App is empty. Now I want to migrate the data from the local to the cloud version.
In the Mendix documentation it is explained that I should open the target app: "To do this, start your app on the database you would like to copy the data to. " (https://docs.mendix.com/howto9/data-models/migrating-your-mendix-database/
chapter 2)
How am I supposed to start the cloudApp in Studio Pro? There I only have the local one.
Or should I start the cloudApp in Browser? But how to put in the custom settings for the source database?
I would appreciate any help.