How can I actualize an importation of DB schema

[Gonçalo Vieira]

Hi!

I’m a new user of EA application and I have some doubts about the importation of the schema of one DB.

So, I imported all DB schema (tables, connection, triggers,…)  through the “Import DB schema from ODBC…” menu, present in “Code Engineering” tool, but now I need some help to improve some functionality in this schema. My questions in this moment that I can not clarify with the EA documentation are:

1. All connection between tables has the style “Custom” and I want to put all connection with styles “Auto-Route”. There is one way that is selecting each one and makes the change manually, but I think that is worst solution. Any one knows how can I make this change automatically?

2. I want to maintain this schema of DB always actualized, but only in one direction, DB to EA schema. Any one knows how can I import only the changes made in the DB without change all schema?

I will be gratefully if some one could help me. If you need more information about I was the importation and I have the schema, please, let me know.

Thanks!
Best regards,
Goncalo Vieira

[«Midnight»]

I think you are out of luck.

[But if I'm wrong, I would love to be corrected! Please chime in people...]

EA sets line style to Custom whenever it does a layout. We seem to have no control over this behavior, and our settings are not respected.

There does not seem to be the equivalent of incremental reverse engineering for databases. At least not for all DBMS products. For example, I don't know if you can get EA to delete tables that have 'disappeared' from the schema. But play around with the settings on import just in case.

David

[Eve]

For 1, it is the auto-layout that sets the connector style to custom so that it can position the connectors exactly as necessary.  If you set the default connector style to auto-routed and turn off diagram layout on import then the connectors will all be auto-routed.

But then you'll just need to manually lay out the diagram.