Penguins Unbound
User:goeko > Database/SQL > Schema

Schema

Page last modified 12:10, 14 Apr 2011 by goeko

     

    Schema Diagraming Tools

    Having to work with a database, more so with a database you didn't design, requires knowing the schema. Here are some tools I found to produce schema graphs and relationship daigrams for a database.

     

    This one is kinda nifty, you an kinda use the example online by loading you schema.

    http://code.google.com/p/database-di...i/Introduction

    I was not able to geti it working on my machine, but I didn't try real hard. (in the web browser console there was an error about 'db not found" ro something like that)

     

    This one looks nices, but requires java.

    http://schemaspy.sourceforge.net/

    How to get a database schema from MySQL

    mysqldump -u root -pmypassword test_database --no-data=true --add-drop-table=false > test_dump.sql  
    

    from this web page

    http://www.postal-code.com/binarycod...st-the-schema/

     

    Here is a link to where I found these

    http://stackoverflow.com/questions/2...-diagram-mysql

    Powered by MindTouch Core