Sunday, May 1, 2011

Loading an existing database into WWW SQL Designer?

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.

From stackoverflow
  • 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.