DBDesigner description
Allows you to handle your databases the most efficient way.
DBDesigner 4 is a visual database design system that integrates database design, modeling, creation and maintenance into a single, seamless environment.
It combines a simple and clear user interface and professional features to offer the most efficient way to handle your databases.
DBDesigner 4 compares to products like Oracle's Designer©, IBM's Rational Rose©, Computer Associates's ERwin© and theKompany's DataArchitect© but is an Open Source Project available for Microsoft Windows© 2k/XP and Linux KDE/Gnome. It is release under the GPL.
DBDesigner 4 is developed and optimized for the open source MySQL-Database to support MySQL users with a powerful and free available design tool.
All MySQL specific features have been built in to offer the most convenient way to design and keep control of your MySQL-Databases.
The
source code of the DBDesigner 4 is available
here.
Here are some key features of "DBDesigner":
· Available on Linux / MS Windows
User Interfaced based on industry standard layouting software
· Canvas navigation similar to Adobe Illustrator® and Photoshop®
· Palettes (docked / floating) including "Bird Eyes view"
· Available objects include tables, realtions, labels, regions, images
· Extensive Drag'n'drop support
· Extensive Popup-Menu support
· Advanced Editors
· UNLIMITED Undo-/Redo- functions
· Copy-/Cut-/Paste clipboard functions (XML, DDL)
· Align functions
· Design Mode / Query Mode
· Reverse engineering MySQL, Oracle, MSSQL and any ODBC databases
· Userdefined schema-generation
· Model-To-Database syncronisation
· Index support
· Automatic foreign key placement
· Weak entity support
· Standard Inserts storing and sync
· Full documentation capabilities
· Advanced model printing
· Output as image
· All MySQL datatypes with all options
· User defined datatypes
· Database storage, ability to save model within database
· Network-/Multiuser access through database storage
· Version control*
· SQL Query Builder
· SQL Command History
· SQL Command storage within model
· Plugin interface
Requirements:
Minimum:
· Pentium 400 MHz
· 128 MB Ram
· 10 MB Harddisk space
Recommended:
· Pentium 2 GHz
· 256 MB Ram
· 20 MB Harddisk space