FAQ

Q2. Is it possible to convert other modeling files (i.g. ERWin) into eXERD files?

A2. In case of ERwin, you can get it after saving as an XML file. In case of other modeling tools, using reverse engineering of eXERD, you can get it indirectly.

Here is an example of reverse engineering an ERwin file created by Oracle forward engineering.

This guide explains how eXERD gets an ERwin model including logical names logical names.

1. Here is a simple example with an ERwin file as follows:
   Note! The example file has logical/physical names respectively.

   

   

2. Select Database > Pre & Post Script > Model-level on ERwin menu.

   

3. Make a new Post Script to change logical names of tables and columns as COMMNET context of Oracle.

   

   Note! In order to apply to all columns and tables, write as follows, using the macro of ERwin.
   %ForEachTable() { COMMENT ON TABLE %TableName IS '%EntityName'; %ForEachColumn() { COMMENT ON COLUMN %TableName.%ColName IS '%AttName'; } }
4. Select Tools > Forward Engineer > Schema Generation.

   

5. Check [Post-Script] of schema item on Options tab.

   

6. Exclude Comments on Other Options.

   

7. If you check the DDL, the logical names of tables and columns are created as Oracle comments. By executing this DDL on Oracle, you can create the tables.

   

8. Now, get the tables created in Oracle by reverse engineering into eXERD. , Select 'Use comment as logical name'.
   Note! eXERD Menu : eXERD > Reverse Engineering

   

9. After finishing reverse engineering, you can check whether all logical/physical names are normal as follows: