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.
+1
A:
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...
matt lohkamp
2008-09-23 09:51:35
+1
A:
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.
che
2008-11-13 03:41:57
A:
You could use VISIO to import the database, it will diagram it for you.
Coolcoder
2008-12-10 09:40:37
A:
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.
Leigh Pyle
2009-04-23 11:00:31
+1
A:
http://code.google.com/p/database-diagram/
This takes a SQL structure (SQL dump) and shows a diagram :)
Very cool. Now it just needs to work with a few more sql types and do a better job of arranging the diagram
Paul Wicks
2009-07-25 15:08:27