Database Builder Import Overwrites Notes

[David Ingleton]

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]

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 

Geert

[David Ingleton]

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