DBDesigner . Fully visual database design system that combines professional features and functions with a simple, clear, and easy-to-use design to provide an effective method of managing databases .
Summary
[ hide ]
- 1 Description
- 2 Features
- 3 Development
- 4 DBDesigner 4 and MySQL
- 5 Sources
Description
DBDesigner, developed by FabForce, is an application for visual database design . It allows to develop a database taking into account the design and functionalities independently of the server / Database Management System that will be used.
DBDesigner compares to Database design products like Rational Rose and ERwin. It is an Open Source project available for Microsoft Windows NT / XP / Vista / 7 and Linux KDE / Gnome. It is distributed under a GPL license .
It is capable of working with MySQL , Oracle , MSSQL and any ODBC, so it can be used with almost all existing databases.
Features
- It allows you to build your database in an intuitive interface and
- easy to use, where you have a visual representation of the tables and relationships that appear in the project.
- It has detailed user manuals.
- The designer can quickly see the fields in a table or how each frame refers to the others.
- You can directly connect to a backend database and build a database there from design.
- You can import from existing databases.
- You can save the project in its original format ( XML) to keep all the information.
- Due to its architecture, DBDesigner is easily extensible to work with multiple database servers. By default it comes with 2 connectors: one for PostgreSQLand the other for MySQL .
- It allows you to manage the database, design tables, make manual SQLrequests and much more.
- It works as reverse engineering in managers like MySQL, Oracle, MSSQL and other ODBC databases , XML models .
- It has support for the drag-and-drop function.
Development
The project started on April 28, 2001, the latest release of this software is DBDesigner 4.0.5.6.
DBDesigner 4 and MySQL
DBDesigner 4 is developed and optimized for the open source MySQL database manager.
All MySQL-specific features have been built into DBDesigner in order to offer the most convenient way to design and maintain control of databases developed in MySQL.