Author Topic: Database Builder Import Overwrites Notes  (Read 1050 times)

David Ingleton

  • EA Novice
  • *
  • Posts: 12
  • Karma: +0/-0
    • View Profile
Database Builder Import Overwrites Notes
« on: November 28, 2019, 08:59:00 pm »
Hi, I am running EA v15 using Pro Cloud Server. I have created a data model by reverse engineering a SQL Server database and enriched it. One of the enrichments is to load column descriptions using Geert Bellekens Excel import to bulk load. This worked very well, placing the new descriptions in the Notes window. However, when I update a column using Database Builder by importing from ODBC the Notes are deleted even though I have selected the option to ignore Remarks and no remarks show in the database compare window. I notice a bug was raised about this for v12 but does anyone know of a workaround as it seems Sparx does not see it as urgent!

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 11849
  • Karma: +460/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Database Builder Import Overwrites Notes
« Reply #1 on: November 29, 2019, 03:47:43 pm »
A (very dirty) workaround would be to create a trigger in the database that undoes any changes made to the t_attribute.notes field and another one for the t_object.note field.

Then delete the triggers after reverse engineering the database.

It would be dirty, but effective  :-X

Geert

David Ingleton

  • EA Novice
  • *
  • Posts: 12
  • Karma: +0/-0
    • View Profile
Re: Database Builder Import Overwrites Notes
« Reply #2 on: November 29, 2019, 08:33:55 pm »
Thanks for the suggestion Geert. As we are moving to automating the synchronisation process, maybe that could be incorporated in the code. I will make that suggestion.

David