14 people following this project (follow)

Welcome to Database Modeling Excel Project Home Page
screenshot1.PNG

Current release: 3.2.3 Production Release
Author: Steven Yang (Need a job in Canada for my PR)
Please send your email to Steven Yang when you have any question.
Denote the Project

The database modeling utility is a MS Excel workbook which can help you on your work of design database.
It supports MySQL, SQL Server and Oracle.
In the workbook, you can define database, generate SQL scripts and reverse database definition from database.
  • 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 up?
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

Last edited May 23 2009 at 8:10 AM by StevenYang, version 37