Chapter 16 Migrating from ERwin to PowerDesigner

File types

PowerDesigner supports the import of the following ERwin file types:

• ERwin v3.x (.erx)
• ERwin v4.x (.xml) - preferred file type, due to the greater amount of metadata available.

ERwin and PowerDesigner implement database design in different ways.

• An ERwin logical model can be imported into either:
  
  
  • a PowerDesigner conceptual data model (CDM), or
  • a PowerDesigner logical data model
• An ERwin Physical Model is imported into a PowerDesigner physical data model (PDM)

In the PowerDesigner Physical Data Model you can use two design levels: the logical model allows you to design the database structure and perform some database denormalization actions without taking into account any DBMS physical requirement. The physical model allows you to design the database taking into account the physical requirements of a given DBMS

Copyright (C) 2005. Sybase Inc. All rights reserved.