WWW SQL Designer allows users to create database designs, which can be saved/loaded and exported to SQL scripts. Various databases and languages are supported. Ability to import existing database design.
About
Hi and welcome to WWW SQL Designer! This tool allows you to draw and create database schemas (E-R diagrams) directly in browser, without the need for any external programs (flash). You only need JavaScript enabled. The Designer works perfectly in Mozillas (Firefox, Seamonkey), Internet Explorers (6, 7, 8), Safari and Operas. Konqueror works, but the experience is limited.
Many database features are supported, such as keys, foreign key constraints, comments and indexes. You can either save your design (for further loading & modifications), print it or export as SQL script. It is possible to retrieve (import) schema from existing database.
Install
Download file from here (http://code.google.com/p/wwwsqldesigner/downloads/list)，you will get a file named "wwwsqldesigner-2.x.zip"。Uncompress this file and open wwwsqldesigner/index.html, then you can use it directly.
If you want to store sql modelling data into mysql, so you need to put this downloaded file into you mysql-php server.
To make the save and load feature working follow this steps:
1. Open wwwsqldesigner/backend/php-mysql/index.php
2. In setup_saveloadlist function change SERVER, USER, PASSWORD and DB to fit your configuration
3. Import in DB the file wwwsqldesigner/backend/php-mysql/database.sql
To make the import from db feature working follow this step :
1. Open wwwsqldesigner/backend/php-mysql/index.php
2. In setup_import function change SERVER, USER, PASSWORD
The process for other server import should be similar.
沒有留言:
張貼留言