Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: David Ingleton on November 28, 2019, 08:59:00 pm

Title: Database Builder Import Overwrites Notes
Post by: David Ingleton 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!
Title: Re: Database Builder Import Overwrites Notes
Post by: Geert Bellekens 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
Title: Re: Database Builder Import Overwrites Notes
Post by: David Ingleton 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