I've used WWW SQL Designer several times to design databases for applications. I'm now in charge of working on an application with a lot of tables (100+ mysql tables) and I would love to be able to look at the relations between tables in a manner similar to what WWW SQL Designer provides. It seems that it comes with the provisions to hook up to a database and provide a diagram of its structure, but I've not yet been able to figure out exactly how one would do that.
-
Can you just export the sql query that builds your existing tables, and run that in WWW SQL Designer? Most database management software has that option...
-
Looking at the interface of the designer, I guess that when you run it on your own PHP/MySQL server, you should be able to import existing database with "Import from DB" button in Save/Load dialog.
-
You could use VISIO to import the database, it will diagram it for you.
-
btw, have you tried SchemaBank? They are web-based and support MySQL fairly well. It eats your sql dump and generates the tables and relationships for you.
-
http://code.google.com/p/database-diagram/
This takes a SQL structure (SQL dump) and shows a diagram :)
Paul Wicks : Very cool. Now it just needs to work with a few more sql types and do a better job of arranging the diagram
0 comments:
Post a Comment
Note: Only a member of this blog may post a comment.