data migration not as I expected - Mendix Forum

data migration not as I expected

0

hi Mendix community, I get a data migration question

I followed the how-to:https://docs.mendix.com/howto/data-models/migrating-your-mendix-database

in order to figure out it deeply, I set up a local mysql database to test it, and here are my steps:

step1. set Database as follow:

step2. set Custom as follow:

Step3. clear the two databases(haha as main database, gaby as source database)

step4. create 1 table named test in gaby(source database)

 

after the 4 steps , I start the app, and I expected test from gaby(source database) will migrate(copy) to haha.

here is the result:

  1. show first pop-up

  1. click it and check the haha(main database), 35 system tables and 1 domain table created, and no change happend in gaby(source database)

  1. show second pop-up 

  1. chec gaby, 37 system(a language  table and it also appeared in haha, I think it can be ignored) and 1 domain table created(or copied) and

 

the app run successfully, here is my question: I expected the ‘test’ table copy from gaby(source database configured in custom tab) to haha(main database), but it seems the ‘test’ table still in gaby.

asked
1 answers
0

The mistake you make is that the Mendix model reflects how the database should look. So any adjustments outside of the model (like creating your own table) wil be lost. Only entities in your model will be created. You can check it yourself when you adjust your settings to a database name that is not there at all. Mendix will create the database and all the tables.

Regards,

Ronald

 

answered