ERD to Database, Database to ERD

Generate database from ERD. Reconstruct structure of a legacy system. Or jump start for a new one.

  1. Database Design
  2. Database Generation/Reversal
  1. Generate Database from ERD  

    Design database in ERD, and generate it. The database generation tool validates your database design and produces the database initialization scripts required for database construction.

    Enhancement

    • Supported specifying and generating SQL with database index that contains function

      You can now specify the the function to use in creating a database index, under the Index specification window of an entity.

    • Supported specifying and generating SQL for unlogged table (PostgreSQL)

      PostgreSQL users can now specify an entity as unlogged through its specification window. Make sure PostgreSQL has been selected under the Database Configuration window (Tools > DB > Database Configuration...)

    Generate database from ERD
  2. Generate Database Patch Scripts

    Generate Database Patch Scripts

    Revise database design, and patch the changes to database. The database patch tool analyzes your database and produces the update scripts required to patch changes. Sophisticated checking would be applied to ensure patching will work whilst keeping existing data intact.

  3. Reverse Engineering ERD from Database

    Working with legacy database becomes even more challenging when the documentation has been lost in time. Make it available again by reverse-engineering the ERDs. Visually study the table structures and their relationships.

    Reverse Engineering ERD from Database
  4. Wide Range of DBMS Support

    Supports database generation and reversal for all popular databases in the market, including MySQL, MS SQL Server, Oracle, Sybase, PostgreSQL, HSQL, MariaDB, Derby, Informix, Firebird, SQLite, IBM DB2, FrontBase, H2, Amazon Redshift and etc.

    Wide Range of DBMS Support