Huz's Website

Easy Software

EZDML

 

EZDML is a small tool which helps you to create data models quickly. It's simple and fast, with EZDML you can create a table within few seconds.
 

main



Features:

  • Diagram layout with logical and physical models
  • Text script to create models quickly
  • Import and Export database (oralce, mysql, sqlserver and ODBC)
  • Generate codes: C++, Pascal, c#, java

EZDML support English and Chinese language.

 

Usage:
1. The programe will automatically read the DMH file in the EXE path, and save it on exit
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 direction
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). For example:

TestTable
--------
ID PK
RID FK
Title S(200)
ItemCount I
ItemPrice F(10,2)
OrderDate D
Memo S

4. Foreign keys can be added and displayed in the diagram
5. Importing and exporting to ORACLE, MYSQL, SQLSERVER and ODBC supported
6. Without database connection, you can also generate DDL SQL for creation only; only when connected will the generation 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.

Version history:

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



2019-12-07 V2.36
Independent configuration files for English and Chinese, Sketch-Mode for generating SQL. Bugs fixed.



2019-11-09 V2.35
Drag and drop tree-nodes to copy fields/tables. Auto save for scripts. 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-08-27 V2.23
Detect file changes, FK-line optimize, new libpq.dll, sort tables by name. 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-04-29 V2.21
Support JSON format, dmh and dmj format modified. 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.



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-09-02 V2.17
Batch generation of code files. Bugs fixed. 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.



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



2017-03-23 V2.14
Gen recreate table sql. 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.



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



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



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



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



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



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



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



2012-10-28 V1.96
Add html form generator. Bugs fixed.



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



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



2011-06-08 V1.81
Batch add or import fields to more than one table, generate indexes SQL for FK fields, bugs of importing ORACLE indexes fixed.
Color settings for PK and Lines, and scroll bars for model graph.
Backup and restore data rows between ORACLE and SQLServer.
Support batch add/remove fields in popup-menu of the table tree. Bugs fixed.


2011-04-17 V1.73
Support field comments for SQLServer, fully support for SQL Server 2000 and 2005, bugs fixed.

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

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

2010-09-06 V1.59
Pascal-Script with Setting-Panel, bugs fixed.

2010-08-04 V1.57
Support Pascal-Script-Templates, bugs fixed.

2009-12-19 V1.52
Bugs fixed.

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

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

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

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

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

 

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-8-29 V1.30
Support SQLSERVER and ODBC driver. Support for multi diagram. C++ code generation.

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

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

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


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


Download installer: http://www.ezdml.com/download/ezdml_setup.exe 
http://blog.csdn.net/huzgd
huzzz@163.com
http://www.ezdml.com