ProductsDatabaseSpyDatabase Entity Relationship Diagrams

Graphically display the relationships of database tables and save entity relationship diagrams for reference and external documentation.

The Altova DatabaseSpy® 2010 graphical database Design Editor lets you view and edit the relationships of all your databases through one graphical user interface. You can also employ the database design editor to create entity relationship diagrams to understand a database more easily. You can customize, print, or save your database ER diagrams for reference in external documentation.

DatabaseSpy Entity Relationship Diagrams Supported Databases

The DatabaseSpy® 2010 graphical database designer supports multiple databases and automatically displays correct data types and other specialized features for the following databases:

• Microsoft® SQL Server® 2000, 2005, 2008
• IBM DB2® 8, 9
• IBM DB2 for iSeries® v5.4
• Oracle® 9i, 10g, 11g
• Sybase® 12
• MySQL® 4, 5
• PostgreSQL 8
• Microsoft Access™ 2003, 2007

 Click here to download a fully functional, free 30-day trial of Altova® DatabaseSpy® 2010!

Analyze and Document Complex Databases

The DatabaseSpy® 2010 graphical database design view offers several convenient features to help you analyze and document complex database table relationships. You can use the right-click context menu to easily create an entity relationship diagram for an existing database.

The resulting entity relationship diagram opens automatically and is zoomed at full size in a scrollable view.

Click image to enlarge database tool screenshot

You can drag the rectangle in the overview helper window to navigate the ER diagram, or you can scale the main window to any size for a more complete view.

Click image to enlarge database tool screenshot

You can select any individual table to automatically highlight its relationships to other tables, and you can expand the keys section of the table to see detailed information. When you select any table, its connecting lines are color-coded:

• Blue connecting lines signify references to other tables
• Orange connecting lines signify references from other tables
• Green connecting lines identify table self-references

You can insert sticky notes anywhere in your entity relationship diagram to record special comments to explain design decisions or modifications, or otherwise enhance the documentation value of your table relationship diagram.

You can also select any connecting line in your ER diagram to automatically identify and highlight the related tables.

Click image to enlarge database tool screenshot

You can drag tables and relationship lines to reorganize the diagram as you like. You can even save the entity realtionship diagram – with your changes – as a design file, print it, or export a copy as an image file for use in a report or other documentation.

See for yourself how the DatabaseSpy® 2010 graphical database Design Editor, along with the Online Database Browser and SQL Editor, can help you analyze, and modify, design and document the structures of your own databases. Click here to download your free 30-day evaluation today!