2 messages in com.mysql.lists.win32Off-line database designer for MySQL
FromSent OnAttachments
Tonci04 Sep 2002 04:22 
Tonci04 Sep 2002 06:04 
Subject:Off-line database designer for MySQL
From:Tonci (tgr@artronic.hr)
Date:09/04/2002 04:22:01 AM
List:com.mysql.lists.win32

Hi to all. After some time ARTRONIC comes with news.

Professional database developers and beginners alike often have difficulty using the tools supplied with standard SQL servers to create database structures. A word processor or even paper and pencil end up being tools used to design the tables fields and links. The developer creates a SQL script to implement part of the design and executes it. The inevitable errors require that the script be corrected and executed again -- and again -- and again. When the bugs have been removed, the proper data types confirmed and the links fitted, a change in specification frequently requires the process to begin again.

We have designed an off-line database designer for MySQL featuring database schema, autocreation of DDL scripts, table links... Free test version URL is http://www.artronic.biz/index.php?pg=44. This version has all of the features except saving the design and printing of design/DDL script so you can test the usage fully.

ARTRONIC DATABASE DESIGNER FEATURES ArtDes is a convenient database designing tool. Its Graphical User Interface makes it easy to describe the structure of tables, indexes, links and function. When the design is complete, SQL script for MySQL server is generated. According to the principles of database creation accepted in ArtDes, the process of database designing consists of the following stages:

Describing of common information about project Creation of the tables with their fields and indexes Creation of links between the tables Definition of Queries Creation of UD Functions Creation of schema for the project Representation of database structure and Visual creation of links between the tables DDL script creation in the format of MySQL server