Database Modeling Excel

Welcome to Database Modeling Excel Project Home Page


Current release: 3.2.1 Production Release
Author: Steven Yang
Please send your email to Steven Yang when you have any question.
Denote the Project

• Why choose this as your database modeling utlity?

There are some excellent and professional utilities in designing database, like ER-Win, Rose, Visio, et cetera…
Why do I create a new one to mess the world?
In my first time to design a database schema, the first thing was selected a suitable utility for my task.
And I realized user was not only me as a designer, and also were developer.
So I listed some requirements for database modeling utility I would use:

1. Design one time, and don’t need any other repeated work.
2. It should be have label information that related with a field, the information would be displayed on UI.
3. It should be have comment information that related with a field, the information would include some note for the field.
4. Developer can read table schema definition directly.
5. It should have a fine print function, so developer can print table schema definition and read them on paper.
6. It should generate relationship diagrams.

I researched ER-Win, Visio and Rose, they were not satisfied with all my requirements.
So I wrote this utility and used ER-Win for generating relationship diagram.

Database Modeling Excel can help you to design database schema.

• Main Features
• Supported Databases
• MySQL
• Oracle
• SQL Server
• Design and maintenance database schema
• Generate script of database schema using workbook’s content.
• Create Tables SQL
• Drop Tables SQL
• Drop and Create Tables SQL
• Create Tables IF Not Exists SQL
• Support ignore some worksheets when generating SQL scripts
• Reverse database schema from database into the workbook
• Support automatic build process
• Fine print (A4 paper)
• News
• Version 3.2.0 was released on 2007/07/26
• Frequently Asked Questions (FAQ)
• Project information (the text from your project description, for example)

This database modeling utility is an excel workbook to help you to design database.

• Project documentation
• Development methodologies
• Release process
• Current issues