It is possible to retrieve (import) schema from existing database. You can either save your design (for further loading & modifications), print it or export as SQL script. Many database features are supported, such as keys, foreign key constraints, comments and indexes. The Designer works perfectly in all browsers. It has a nice schema visualization tool that also enables you do design with ER diagrams. MySQL Workbench simplifies database design and maintenance and improves communication among DBA and developer teams. If you’re more comfortable with the GUI approach then try out Joachim Uhl’s SchemaSpyGUI. SchemaSpy uses Graphviz, specially the dot program to generate graphical representations of the table/view relationships. It lets you click through the hierarchy of database tables via child and parent table relationships as represented by both HTML links and entity-relationship diagrams. SchemaSpy is a Java-based tool (requires Java 5 or higher) that analyzes the metadata of a schema in a database and generates a visual representation of it in a browser-displayable format. Below are given various database diagramming and visualization tools that will help you make sense of your complex database designs. Also, it can be useful when you need to reverse engineer a big schema and need to understand the various relationships between different tables. Database schema visualization is an essential process during the initial project design phase.
0 kommentar(er)
