Design to Database Schema

Transform design to database. Reconstruct structure of a legacy system. Or jump start for a new one.

Database generation

You can generate database schema (DDL) from Entity Relationship Diagram (ERD). Database generation engine generates full database initialization scripts and alter statements for updating existing databases. The latest version supports updating database constraint. The following movie shows how to generate database from ERD.

YouTube

How to generate DDL from your ERD

Turn back time with legacy 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.

Wide range of database support

Visual Paradigm for UML supports database generation and reversal, and ORM for all popular databases in the market, including MySQL, MS SQL Server, Oracle, Sybase, PostgreSQL, Derby, Informix, Firebird, SQLite and etc. The following screenshot shows the database configuration screen with a list of supported database.