Book a Demo

Author Topic: Synchronization from DB2 database  (Read 3369 times)

ihenales

  • EA Novice
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
Synchronization from DB2 database
« on: May 09, 2019, 05:23:14 pm »
Hi,

I have a question regarding the synchronization of one model taking the tables from a DB2 database. I have taken all the tables from that database, and built the model on EA. But I would like to know if it is posible to synchronize one table when any change in the database is made mantaining all the connectors and the model as it is (I mean, without importing again the table, and making all the connectors). The problem is that when i click on the synchonize button (code section) it appears one message that tells me that DB2 is an unsupported language.

Thanks.

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Synchronization from DB2 database
« Reply #1 on: May 10, 2019, 01:49:22 am »
You should use the database builder to synchronize with DB2, not the code generation feature.

Geert


ihenales

  • EA Novice
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
Re: Synchronization from DB2 database
« Reply #2 on: May 15, 2019, 08:09:54 pm »
Hi again,

I have started to use the Database Builder and I have imported some tables from the DB2 database. But when I try to import them again to do the synchronization, the associations dissapear. I am doing this step pressing again the button "Import DB schema from ODBC" and I think this action is incorrect. I think it has something to do with the section "Database compare" in Database Builder, but there is nothing in this section (I mean, it is completely empty, although I choose one table in the Database Builder), and when I press the buttons, it does not work or the EA crashes. Any idea of how can I do the synchronization?

Thanks.

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Synchronization from DB2 database
« Reply #3 on: May 15, 2019, 08:53:58 pm »
What do you mean by Associations?
Do you mean Foreign Key relations you added after importing the tables?
If you then re-import the tables it seems logical that these would disappear again as these FK's are not present in the database.

The compare features should give you a itemized overview of all changes, allowing you to decide what should be done for each change.

If it doesn't work or crash you better contact support.

Geert