Re: Looking for database design/model software

From: Reuben D. Budiardja (techlist_at_voyager.phys.utk.edu)
Date: 02/09/04

  • Next message: Daniel Carrillo: "Re: Linux Login Script" 
    To: redhat-list@redhat.com
Date: Mon, 9 Feb 2004 13:27:13 -0500

    On Monday 09 February 2004 12:13 pm, Ben Yau wrote:
    > Hi all.
    >
    >
    > Does anyone here know of a database design/modeling software that runs on
    > redhat? Preferably free? At the least I would need is just something to
    > draw the diagrams with and put in the table information. If it could
    > generate SQL, that's a huge huge plus.

    I use Dia (http://www.lysator.liu.se/~alla/dia/), which is included in RH
    distro, to draw diagram for the tables relationship in my database. Since Dia
    file is XML based, I actually have a small PHP script that takes the input of
    a SQL file containing description or SQL script to create the tables, and
    feed it into another script that turns it an XML file for Dia. I then open
    the XML file using Dia and all I need to do is to draw the relationship
    connector, since I'm lazy to actually type in anything into Dia (I'd rather
    write the SQL script to create tables). The PHP script is not perfect and has
    its idiosyncrazy (sp?) , but it does the job for me to generate a rather nice
    looking documentation. You may contact me offlist if you wish.

    If I understood you correctly, what you want seems to be the other way around.
    You want to draw and put in the table information graphically, and then
    generate the SQL script. It should not be very hard to write a script that
    takes the XML file of Dia and turn it into SQL file.

    By the way, what database are you using? If you're using PostgreSQL, there is
    pgaccess. If you're using Oracle, you may want to check "Tora" out. I've
    never actually use those tools for designing other than as a nice simple GUI
    interface to quickly lookup my table description since I'm more of a SQL
    console user.

    Hope that helps.
    RDB 

    -- 
Reuben D. Budiardja
Department of Physics and Astronomy
The University of Tennessee, Knoxville, TN
---------------------------------------------------------
"To be a nemesis, you have to actively try to destroy 
something, don't you? Really, I'm not out to destroy 
Microsoft. That will just be a completely unintentional 
side effect."
                 - Linus Torvalds -
-- 
redhat-list mailing list
unsubscribe mailto:redhat-list-request@redhat.com?subject=unsubscribe
https://www.redhat.com/mailman/listinfo/redhat-list
  • Next message: Daniel Carrillo: "Re: Linux Login Script"

    Relevant Pages

    • Re: Vista hosting XPe tools/db
      ... Are you running this script on the machine that actually has the SQL server ... machine hosting the database. ... i don't know if you can install a second instance of SQL ...
      (microsoft.public.windowsxp.embedded)
    • Re: ActiveX script works in DTS but not in job, why?
      ... Account that SQL Agent runs under and it is a Local Admin on the box. ... As another test I saved the script as a .vbs file and tried running it, ... Microsoft OLE DB Provider for SQL Server ... that would be since I need to be able to load DTS packages from either a SQL ...
      (microsoft.public.sqlserver.dts)
    • Re: Vista hosting XPe tools/db
      ... here's an alternative script using the Microsoft ADO as ... opposed to the SQL DMO - this should allow this script to work ... Microsoft Windows XP Embedded Test Team ... This posting is provided "AS IS" with no warranties, and confers no rights. ...
      (microsoft.public.windowsxp.embedded)
    • Re: Enterprise Manager Newbie Question
      ... a SQL backup is not a simple copy of the database files. ... Is it possible to write a script that one could run from a workstation and ...
      (microsoft.public.sqlserver.tools)
    • Re: using xml to save/open project data
      ... http://www.TransProCalc.org - Free translation project mgmt software ... set filename tk_getOpenfile ... Exec'ing the script you run it as a separate process, your script won't be able to access its vars. ... generating the xml file is easy enough. ...
      (comp.lang.tcl)