Database Modeling Excel

UPDATED RELEASE: 3.2.1 Production Release (Jul 26, 2007)

Tue, 08 Apr 2008 10:06:00 GMT

_Happy Your Life_
Let's go further.

* 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)

UPDATED WIKI: Home

StevenYang — Tue, 08 Apr 2008 09:21:15 GMT

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:

Design one time, and don’t need any other repeated work.
It should be have label information that related with a field, the information would be displayed on UI.
It should be have comment information that related with a field, the information would include some note for the field.
Developer can read table schema definition directly.
It should have a fine print function, so developer can print table schema definition and read them on paper.
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

UPDATED RELEASE: 3.2.1 Production Release (Jul 26, 2007)

Tue, 08 Apr 2008 09:18:33 GMT

UPDATED WIKI: Home

StevenYang — Mon, 30 Jul 2007 06:04:43 GMT

Welcome to Database Modeling Excel Project Home Page

Current release: 3.2.0 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?

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

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

UPDATED WIKI: Home

StevenYang — Mon, 30 Jul 2007 05:59:29 GMT

Why choose this as your database modeling utlity?

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

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)

An excel workbook is to help you to design database.
You can define database model in the workbook.
And some macros can help you to generate some SQL scripts.
It also can reverse database schema to the workbook.

Project documentation
Development methodologies
Release process
Current issues

UPDATED WIKI: Home

StevenYang — Mon, 30 Jul 2007 03:18:49 GMT

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)

Project documentation
Development methodologies
Release process
Current issues

UPDATED WIKI: Home

StevenYang — Thu, 26 Jul 2007 08:46:06 GMT

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)

An excel is to help you do database design.
You can edit database model in the excel.
And some macros can help you generate some SQL scripts.
also it can reverse database to the excel.

Project documentation
Development methodologies
Release process
Current issues

UPDATED WIKI: Home

StevenYang — Thu, 26 Jul 2007 08:43:07 GMT

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

**3.2.0 was released on 2007/07/26

Frequently Asked Questions (FAQ)
Project information (the text from your project description, for example)

An excel is to help you do database design.
You can edit database model in the excel.
And some macros can help you generate some SQL scripts.
also it can reverse database to the excel.

Project documentation
Development methodologies
Release process
Current issues

UPDATED RELEASE: 3.2.0 Production Release (Jul 26, 2007)

Thu, 26 Jul 2007 08:43:03 GMT

CREATED RELEASE: 3.2.0 Production Release (Jul 26, 2007)

Thu, 26 Jul 2007 08:31:28 GMT

_Happy Your Life_
Let's go further.

* Database supported
** MySQL
** Oracle
** SQL Server
* Edit database schema
* Generate script of database schema base on 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 building process
* Support print default A4 paper.

UPDATED RELEASE: 3.1.0 Production Release (Jul 23, 2007)

Tue, 24 Jul 2007 01:18:00 GMT

_Published on 2007/07/12_
Happy coding

* Support SQL Server
Can generate SQL scripts and can reverse table schema from SQL Server.
* Support MySQL
Can generate MySQL scripts and can reverse table schema from MySQL.
* Support Oracle
Can generate Oracle scripts and can reverse table schema from MySQL.
* Support build process
Can generate SQL scripts from command line.
* Add help document
* Support ignore some worksheets when generating SQL scripts

RELEASED: 3.1.0 Produce Release (Jul 23, 2007)

Mon, 23 Jul 2007 00:53:42 GMT

CREATED RELEASE: 3.1.0 Produce Release (Jul 23, 2007)

Mon, 23 Jul 2007 00:53:42 GMT

UPDATED WIKI: Home

StevenYang — Fri, 13 Jul 2007 03:37:18 GMT

Welcome to Database Modeling Excel Project Home Page

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

Database Modeling Excel can help to design database schema.

Supported Databases:

SQL Server
MySQL
Oracle

Functions:

Edit database schema
Generate script of database schema base on workbook’s content.
Reverse database schema from database into the workbook
Support building process
Easy edit.
Easy read.
Easy print.
Support A4 paper for print.

News

**3.0 RC1 is released on 2007/07/12

Frequently Asked Questions (FAQ)
Project information (the text from your project description, for example)

An excel is to help you do database design.
You can edit database model in the excel.
And some macros can help you generate some SQL scripts.
also it can reverse database to the excel.

Project documentation
Development methodologies
Release process
Current issues

UPDATED RELEASE: 3.0.0 Release Candidate 1 (Jul 12, 2007)

Fri, 13 Jul 2007 03:17:06 GMT

UPDATED RELEASE: 2.0.0 Release Candidate 1 (Jun 15, 2007)

Tue, 19 Jun 2007 00:41:54 GMT

_Published on 2007/06/15_ Happy coding * Support SQL Server Can generate SQL scripts and can reverse table schema from SQL Server. * Support MySQL Can generate MySQL scripts and can reverse table schema from MySQL. * Fixed some bugs

UPDATED WIKI: Home

StevenYang — Fri, 15 Jun 2007 09:14:00 GMT

Welcome to Database Modeling Excel Project Home Page

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

Database Modeling Excel can help to design database schema.

Supported Databases:

SQL Server
MySQL

Functions:

Generate SQL script.
Reverse tables schema from database
Easy edit.
Easy read.
Easy print.

News

2.0 RC1 is released on 2007/06/15

Frequently Asked Questions (FAQ)
Project information (the text from your project description, for example)

An excel is to help you do database design.
You can edit database model in the excel.
And some macros can help you generate some SQL scripts.
also it can reverse database to the excel.

Project documentation
Development methodologies
Release process
Current issues

UPDATED RELEASE: 2.0.0 Release Candidate 1 (Jun 15, 2007)

Fri, 15 Jun 2007 09:12:31 GMT

_Published on 2007/06/15_ Happy coding * Support MySQL Can generate MySQL scripts and can reverse table schema from MySQL. * Fixed some bugs

UPDATED RELEASE: database modeling template 2.0.0 rc1 (Jun 15, 2007)

Fri, 15 Jun 2007 09:10:31 GMT

_Published on 2007/06/15_ Happy coding * Support MySQL Can generate MySQL scripts and can reverse table schema from MySQL. * Fixed some bugs

UPDATED WIKI: Home

StevenYang — Fri, 15 Jun 2007 08:51:40 GMT

Welcome to Database Modeling Excel Project Home Page

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

Database Modeling Excel can help to design database schema.

Supported Databases:

SQL Server
MySQL

Functions:

Generate SQL script.
Reverse tables schema from database
Easy edit.
Easy read.
Easy print.

News

2.0 RC1 is released on 2007/06/15

Frequently Asked Questions (FAQ)
Project information (the text from your project description, for example)

An excel is to help you do database design.
You can edit database model in the excel.
And some macros can help you generate some SQL scripts.
also it can reverse database to the excel.

Project documentation
Development methodologies
Release process
Current issues