Unanswered: A practical newbie question involving r/s schema involving mysql
Hi I hope to gain some pointers from the guys here.
I have a MySQL database where the tables have been defined as MyISAM and I wish to develop the schema which shows the relationship of the tables. Initially I exported the database to MS access using ODBC to develop the schema (due to the foreign key problem in MySql).
Is there a way for me to develop the schema without involving MS access so that I can do it using mySQL or any opensource program?
The schema is a graphical representation of the tables and their r/s between them, as in MS access.
Here something you can try. Does mysql allows you to export all tables
as sql script? If so...
Grab Case studio (Data modeling software trial/beta) from Cnet download and import this sql file to create schema.
Most of Case tool will allow you to build(reverse engineer) schema
from SQL script.