Database Designer for MySQL makes the process of database creation clear and simplifies maintenance of the databases. All the operations are being performed in a fast, handy and intuitive interface.
- Draw the Database
Place objects that would be in your database on a diagram, a virtual sheet of paper. See and realize the structure of your database and its objects: tables, views, stored procedures, functions and relationships between them. Construct tables, indexes, columns. You can make use of already existing databases by reverse engineering them.
- Easy Database Creation and Maintenance
With database designer you can quickly create a ready-to-use MySQL database with a few clicks, and then keeping its structure up-to-date by synchronizing it with the changes you made to visual diagram. Simply change the diagram - Designer will generate complex SQL statement for database modification that keep data safe for you. Moreover, you can synchronize several databases to the state of your diagram.
- Documentation: Printing, Generating Graphics and Reports
Generate powerful reports that describe all the database objects within your diagram. You can additionaly export graphical representation of diagram to EMF, JPEG, PNG, GIF and other popular formats or print the diagram out on multiple pages.
The product designed for popular MySQL database server and takes into account all its features including:
MicroOLAP Database Designer for MySQL allows to construct your database in easy-to-understand visual environment by working with graphical representation of tables, columns, relations and so on.
- MySQL’s extensions of SQL syntax;
- all MySQL types of the tables: MyISAM, ISAM, InnoDB, BDB (Berkeley DB), ...
- MySQL references;
- stored procedures and functions;
- all MySQL field types (including MySQL ENUM and SET fields)...
This product allows to extract tables, attributes, relationships, indexes and other objects from existing databases including MySQL, Microsoft Access and Sybase ASE/ASA, Oracle, Informix, MSSQL, DB2, DBF and many others that accessible through OLEDB or ODBC and import (reverse engineer) them into your diagram.
Finally you will get Physical Entity Relationship Model (ER Model) that can be exported in SQL script, or directly built on working MySQL database server. After your database model/diagram is modified, you can synchronize existing MySQL database with it.