DBdesigner

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.

 

by Abdullah Sam
I’m a teacher, researcher and writer. I write about study subjects to improve the learning of college and university students. I write top Quality study notes Mostly, Tech, Games, Education, And Solutions/Tips and Tricks. I am a person who helps students to acquire knowledge, competence or virtue.

Leave a Comment