Huz's Website

Easy Software

News:


Download EZDML

EZDML video tutorial at downloadtube.com EZDML antivirus scan report at downloadtube.com

Video Tutorial

EZDML

for windows / mac OS / linux

 

EZDML is a small tool which helps you to create data models quickly. It's simple and fast, with EZDML you can create tables within few seconds and customize template-scripts to generate code files.
 
Screen shots of windows:

main

mac OS:

main

linux:

main



Features:

  • Table model design: create table, fields, primary key, foreign key and comments
  • Text script to create models quickly
  • Diagram layout with logical and physical model views
  • Import exists tables from database (ORACLE, MYSQL, SQLSERVER, SQLITE, POSTGRESQL)
  • Generate database DDL SQLs, compare with exists object to genarate proper SQLs
  • Generate simple codes: C++, Pascal, c#, java, etc, templates can be customized and you can create new templates.
  • Support Pascal-script and JavaScript.

EZDML support English and Chinese language.

 

Usage:
1. The programe will automatically load the last model file on start
2. In the diagram, you may following function keys: + zoom in, - zoom out, R restore, F fit selection (or all), Left/Right/Up/Down for panning. Support Ctrl + mouse-wheel zooming and Alt + mouse-dragging panning.
3. In the text script editor, you can use simple letter to present data types: S, I, F, D, BO, E, BL, O (String, Integer, Float, DateTime, Boolean, Enum, Blob, Object), default is String.

For example:

TestTable
--------
ID  PKInc
RID FK
Title S(200)
OrderNo I(20)
ItemCount I
ItemPrice F(10,2)
OrderDate D
Desc Describ
TpNa TypeName String:NCLOB
Icon BL
RichText S(99999)
IsEnabled BO
Memo

4. Foreign keys can be added and displayed in the diagram
5. Importing from and exporting to ORACLE, MYSQL, SQLSERVER, SQLITE and POSTGRESQL
6. Without database connection, you can also generate DDL SQL for creation only; when connected the generation will make compared SQL
7. To avoid data loss, the programe will still generate SQL to Drop objects, but these SQLs will be marked as comments
8. This soft is free for any use. The author assumes no liability for damages, direct or consequential, which may result from the use of the Software. The user must assume the entire risk of using the Software.



huzzz@163.com
http://www.ezdml.com
QQ group: 344282607
Forum: http://www.ezdml.com/bbs

Version history:
2009-2-18 V1.21
This tool project started from Apr 2006, so version number is 1.2 now

2009-2-22 V1.22
Some precision bugs fixed

2009-6-5 V1.23
Improvements of importing, exporting, foreign link. Support new data types: objects, functions and events.

2009-7-15 V1.24
Index creating bug fixed. Auto deal with long index name. Check hint for invalid field names.

2009-8-29 V1.30
Support SQLSERVER and ODBC driver. Support for multi diagram. C++ code generation.

2009-9-12 V1.32
Generate DML and DQL SQL. Import and export table comments. Add foreign key in diagram. Remember database connection info. Bugs fixed. Support for english

2009-9-25 V1.34
Model diagram color style settings, copy image to clipboard, bugs fixed.

2009-10-11 V1.35
Big application icon, use English by default.

2009-10-21 V1.36
Bugs of importing database object fixed.

2009-11-8 V1.40
Support for MYSQL, some bugs fixed.

2009-11-25 V1.42, 2009-11-29 V1.50
Export to excel, some improvements and bugs fixed.

2009-12-19 V1.52
Bugs fixed.

2010-4-20 V1.55
Support Pascal-Script-Templates, bugs fixed.

2010-9-6 V1.59
Pascal-Script with Setting-Panel, bugs fixed.

2010-12-1 V1.62
Search and import fields from exists table. bugs fixed.

2010-12-20 V1.63
Support auto-increment fields for MySql and SQLServer.

2011-3-15 V1.64
Drag and drop to open a file, recent file list.

2011-4-7 V1.71
Support field comments for SQLServer, fully support for SQLServer2005, bugs fixed.

2011-4-23 V1.77
Batch add or import fields to more than one table, generate indexes SQL for FK fields, bugs of importing ORACLE indexes fixed.

2011-5-1 V1.79
Color settings for PK and Lines, and scroll bars for model graph.

2011-5-15 V1.80
Backup and restore data rows between ORACLE and SQLServer.

2011-6-8 V1.81
Support batch add/remove fields in popup-menu of the table tree. Bugs fixed.

2011-7-17 V1.82
Text script support new format like "CusNam NameOfCustomer S(100)". Bugs fixed.

2011-7-25 V1.85
Support ORACLE connections with NSDOA (BA-Platform-Data-Service). Bugs fixed.

2011-9-16 V1.88
Support text or sql entities. Bugs fixed.

2011-10-16 V1.91
Support overview mode.

2011-11-02 V1.92
Add a SQL tool.

2012-10-20 V1.95
Add html form generator, bugs fixed.

2012-10-28 V1.96
Support multi primary keys, generate with selection, bugs fixed.

2014-04-27 V1.97
Auto save & load on exit & start, some other improvements and bugs fixed.

2014-09-29 V1.98
Specail copy, multi entity color, pascal script with template support (like JSP and ASP).

2014-12-07 V1.99
Auto-save, Custom field type list, Custom field type replacements, bugs fixed.

2015-02-09 V2.01
Default field type customize, Sync same name tables, Both logic and physics name mode, bugs fixed.

2015-04-15 V2.02
Support oralce instant-client, generate sql without db-connection, check file date before fast-loading of tmp file, bugs fixed.

2015-09-07 V2.03
Bugs fixed.

2015-10-11 V2.04
Support Sqlite, bugs fixed.

2015-10-19 V2.06
Support PostgreSQL, support Global-Script-Events to generate customized SQL, save db password, bugs fixed.

2015-12-26 V2.11
Export doc and mht with graph UI and code, support UTF-8 charset for ORACLE, bugs fixed.

2016-05-15 V2.13
Prompt if files opened twice, link line auto align, INI switch for ORACLE sequence, New-table template file, paste field prop from excel, bugs fixed.

2017-03-23 V2.14
Gen recreate table sql. Bugs fixed.

2017-08-05 V2.15
Support FK for PK fields, comparing with another EZDML modal to generate SQLs. Bugs fixed.

2018-01-18 V2.16
Create new table on mouse position. Copy image as PNG by default (hold SHIFT for WMF). Export BMP PNG and JPG files. Save temporary files to user TEMP folder and keep history files. Bugs fixed.

2018-09-02 V2.17
Batch generation of code files. Bugs fixed.

2018-11-04 V2.18
Supports selecting fields, copying names and double-clicking to edit fields directly on the model graph, holding ALT to pan the model graph at any time, pressing ALT and click on the left tree to locate the table directly in the model graph. Bugs fixed.

2018-12-16 V2.20
Add constraint to Table-Describe-String, support table-data-preview, generate beeline for links, support include {$I file} for Pascal-Script, support custom tool-menus. Bugs fixed.

2019-04-27 V2.21
Support JSON format, dmh and dmj format modified. Bugs fixed.

2019-07-20 V2.22
Database logon histories, auto recognizes one-to-one FK links, describe text support FKs, custom reserved-keywords, demo files. Bugs fixed.

2019-08-27 V2.23
Detect file changes, FK-line optimize, new libpq.dll, sort tables by name, Bugs fixed.

2019-10-07 V2.32
Custom property UI for tables and fields (edit INI to enable), add TIniFile and CurField for scripts, support JavaScript (BESEN engine), improved auto-arrange algorithms, use ActionList in main form. Bugs fixed.
                
2019-11-09 V2.35
Drag and drop tree-nodes to copy fields/tables. Auto save for scripts. Bugs fixed.
                      
2019-12-07 V2.36
Independent configuration files for English and Chinese, Sketch-Mode for generating SQL. Bugs fixed.

2020-01-23 V2.39
Optimization of automatic routing algorithm, performance optimization for huge file, import pdm files. Bugs fixed.

2020-01-31 V2.41
Auto pan when selecting. Support none-FK-lines. Camel-case conver to underline. UTF-8 encoding for data files. Bugs fixed.

2020-04-11 V3.01
New Settings and About dialog, global event scripts enabled, new app icon, bugs fixed.

2020-05-10 V3.03
Add ODBC connection, new postgreSQL lib files, bugs fixed.

2020-10-18 V3.04
Multi-view-mode for table dialogs, find text in describe-text, horz-layout for script editor, PKInc type. Bugs fixed.

2020-11-22 V3.05
Switch-view-mode for table dialogs, add layuiAdmin template for Code-generation. Bugs fixed.

2021-02-16 V3.06
HTTP remote connection, add JDBC server. Bugs fixed.

2021-03-27 V3.07
Display field properties beside field-list. Independent position for overview-mode. Bugs fixed.

2021-04-24 V3.08
Auto check updates, view table props of database, support complex indexes and bigint/smallint data types. Bugs fixed.

2021-05-30 V3.09
Full-screen mode. Bugs fixed.