Обсуждение: Database Diagrams.
Sorry if this is a question that has been answered in some form or another, but I need to know if there is a toold of some description that will help me get a diagram of my 7.2.1 database with the relationships. I've done various searching on google but found nothing ( but I may be searching with the wrong phrase's etc ). I'm using a Win32 client to develop, but the DB runs on a debian linux server. TIA Geoff ----------------------------------------------------------------------- This message is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you receive this message in error please contact the sender by return e-mail and delete the message from your computer. Any opinions contained in this message are those of the author and are not given or endorsed by Metalogic PLC unless otherwise clearly indicated in this message and the authority of the author to bind Metalogic is duly verified. Metalogic PLC accepts no liability for any errors or omissions in the context of this message which arise as a result of internet transmission. -----------------------------------------------------------------------
Le jeu 18/07/2002 à 09:47, Geoff a écrit : > Sorry if this is a question that has been answered in some form or another, > but I need to know if there is a toold of some description that will help me > get a diagram of my 7.2.1 database with the relationships. I've done various > searching on google but found nothing ( but I may be searching with the > wrong phrase's etc ). I'm using a Win32 client to develop, but the DB runs > on a debian linux server. You can try DbVisualizer : http://www.minq.se/products/dbvis/ I think it's a godd product. There's also dbdoc, I think... > > > > ----------------------------------------------------------------------- > This message is intended only for the person or entity to which it is > addressed and may contain confidential and/or privileged material. Any > review, retransmission, dissemination or other use of, or taking of any > action in reliance upon, this information by persons or entities other than > the intended recipient is prohibited. If you receive this message in error > please contact the sender by return e-mail and delete the message from your > computer. > > Any opinions contained in this message are those of the author and are not > given or endorsed by Metalogic PLC unless otherwise clearly indicated in > this message and the authority of the author to bind Metalogic is duly > verified. > > Metalogic PLC accepts no liability for any errors or omissions in the > context of this message which arise as a result of internet transmission. > ----------------------------------------------------------------------- > > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster > > -- _Stéphane SCHILDKNECHT___________________________________ | AurorA-SAS 69-71, Av. Pierre Grenier 92100 BOULOGNE | | Tel : 01.58.17.03.20 Fax : 01.58.17.03.21 | | mailto:sschildknecht@aurora-linux.com - ICQ : 142504394 | | "Free Markets have taught that innovation is best when | | ideas flow freely." Adam Smith | |_________________________________________________________|
--- Geoff <geoff@metalogicplc.com> wrote: > Sorry if this is a question that has been answered > in some form or another, > but I need to know if there is a toold of some > description that will help me > get a diagram of my 7.2.1 database with the > relationships. -- There is a tool call ERWin (by Platinum software).You can draw you ER Diagram and the program will automatically generate the schema based on the ER diagram you draw. This software is not open source and is not free. -- I think there are free/open source alternatives. Try searching under the category "CASE tool", "ER diagram", etc. -- ludwig __________________________________________________ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com
> > You can try DbVisualizer : > http://www.minq.se/products/dbvis/ > Does anybody know whether it is possible to visualize table dependencies with this tool? It worked fine with Oracle but with postgresql, DbVisualizer did not show any reference even though there where many. I tried org.sourceforge.jxdbcon.JXDBConDriver and org.postgresql.Driver - no difference. Stefan -- ----------------------------- Dr. Stefan Holzheu Tel.: 0921/55-5720 Fax.: 0921/55-5799 BITOeK Wiss. Sekretariat Universitaet Bayreuth D-95440 Bayreuth -----------------------------
Le jeu 18/07/2002 à 12:02, Stefan Holzheu a écrit : > > > > You can try DbVisualizer : > > http://www.minq.se/products/dbvis/ > > > > Does anybody know whether it is possible to visualize table dependencies > with this tool? AFAIK, it is. > > It worked fine with Oracle but with postgresql, DbVisualizer did not > show any reference even though there where many. Are there any foreign key in your tables ? S@S