Importing Data Models from ERWin

[oocldba]

 Hi,
 We plan to migrate Data Models from ERWin and import these into Enterprise Architect (EA 8.0)   Would like to know if this is possible and if anyone has tried this.

 Also, would like to know if "Subject Areas"   in ERWin used to define individual Sub Models under the main Data Model , each Subject Area having only portion of Data Model (group of Tables) relating to Application-specific Module --  is "Subject-Area" supported in EA Data Modelling.

Any feedback on the above is highly appreciated.

Thanks

[Paolo F Cantoni]

hi oocldba (a human name would be helpful),

I can answer that quite precisely...  I'm attempting to round-trip some models between the two as I speak...

The two commercial tools I've tried to do this are less than optimal...

By data model they mean tables ONLY (and for some only parts of the tables).

They've not heard of procedures and functions (and in one case views).

If you are using ERwin to manage your physical DBs, you are better off reverse engineering the DBs into EA directly.  The physical DB is the most effective model interchange mechanism I've found.  Especially if it's going to be a one-way trip.

HTH,
Paolo

[Geert Bellekens]

We recently moved our data modelling from PowerDesigner to EA.
We too concluded that it was best to reverse engineer the actual database, rather then trying to import the data from PowerDesigner directly.

Geert