Skip to main content

ERwin conversion

serge
Updated

Easily migrate your ERwin projects to SqlDBM with full support for physical and logical models. This feature enables teams to modernize their modeling workflows while retaining the structure, relationships, and diagrams from existing ERwin XML files.

 

Overview

SqlDBM supports direct import of ERwin XML models exported in XML Repository Format (fileVersion="10") into new or existing projects.
Once uploaded, SqlDBM automatically converts the ERwin structure to SqlDBM’s internal format, preserving as much detail as possible.

 

💡 Tip: Even if your ERwin project is based on a database platform that SqlDBM doesn’t natively support (e.g., Sybase IQ, Teradata), it can still be imported — the project will simply be created as a Logical model.

 

Supported Project Types

All ERwin project types can be imported:

  • Logical

  • Physical

  • Logical/Physical (hybrid) - imported as physical

If the database type is recognized (e.g., SQL Server, Snowflake, PostgreSQL), the corresponding physical project will be created. If the database type isn’t supported in SqlDBM, a logical project will be generated.

 

What Is Imported

SqlDBM captures all major modeling objects and metadata from your ERwin XML.

Supported Elements

Object Description / Details
Subject Areas Name, description, and associated diagrams
Diagrams Names and objects. Layout and spacing may differ
Schemas Names and logical descriptions
Tables Logical and physical names, descriptions, postscript
Columns Logical/physical names, data types, nullability, default expressions
Keys Primary, alternate, unique, and foreign key definitions
Constraints Check constraints, relationships, and cardinality
Relationships Connection type, cardinality, and display names
Views SQL definition, columns, and visibility
Functions & Procedures Names, descriptions, and scripts

Some advanced ERwin constructs don’t have a direct analogue in SqlDBM. These are preserved where possible or omitted gracefully.

 

Workflow Overview

To migrate an ERwin project to SqlDBM, follow the steps below. 

  1. Verify you are using ERwin fileVersion=10.x

  2. Export the ERwin project in XML format. From the File menu, select "Save As" and choose the "XML Repository Format Files" format. Consult ERwin documentation for more info. 

  3. With the file generated, open a support ticket to complete the process using the ERwin import request and provide the following details:

    1. ERwin XML file (source)

      1. Uploads are restricted to 50MB max files.  

      2. If you file is over 50MB

        1. Try compressing it as a zip file

        2. Otherwise, please provide a link where we can download the XML file

    2. Project name (target)

    3. Project owner (target)

That's it! A project with the specified name will be created for the specified user in your SqlDBM account. 

 

 

Related articles