Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003

    Question 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.

    Thanks and happy new year.

  2. #2
    Join Date
    Jan 2003
    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.

    Hope this helps.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts