Sparx Systems Forum

Enterprise Architect => Automation Interface, Add-Ins and Tools => Topic started by: oocldba on February 11, 2011, 05:45:25 am

Title: Importing Data Models from ERWin
Post by: oocldba on February 11, 2011, 05:45:25 am

 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

Title: Re: Importing Data Models from ERWin
Post by: Paolo F Cantoni on February 11, 2011, 11:36:54 am

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

Title: Re: Importing Data Models from ERWin
Post by: Geert Bellekens on February 11, 2011, 06:14:13 pm

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