Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2004
    Posts
    51

    Question Unanswered: SQL generator software

    Hi,

    I find it tedious to write SQL once I have designed a database. Is there any software out there that will let me automatically generate SQL (specificaly for mySQL databases) once I have made tables and relationships? I have Visio but I don't think it will let me generate SQL once I have made the database diagram...

    Thanks.

    NB
    Last edited by nbozic; 07-04-04 at 02:26.

  2. #2
    Join Date
    Jun 2004
    Posts
    9
    There are a lot of administrative and visual interface for creating and designing MySQL databases on the market....for example EMS MySQL manager from EMS Hi-TEch...you can also download a 30 days trial version from their web site...and of course you can use free softwares such as myadmin a PHP based software for MySQL Administration.....Just check them with a search engine like google...you will find plenty of them both free and not free...

  3. #3
    Join Date
    Mar 2004
    Posts
    51
    Thanks, I'll check it out

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >I find it tedious to write SQL once I have designed a database
    Then I'd say you are in the wrong profession.
    Please explain how some mythical/magical "tool" can KNOW what is to
    be done with the data in the database. Simply being aware that a parent/child
    relationship exists, provides nothing of value to what the business rules are or should be.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I think they call that ErWin.

    -PatP

Posting Permissions

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