Re: [PHP-DB] MySQL software question

2004-07-28 Thread Mikhail U. Petrov
May be ERwin or BPwin can help you.
imho ERwin works with MSSQL, Access, so maybe new versions work with 
MySQL too.
Vincent Jordan wrote:

Is there a piece of software that will allow my to create MySQL
databases and table relations in a graphical format without having to
connect to the database?
I am looking for something where I can point and click the creation of
tables and easily create several relationships between tables ( kinda
like in access ) and when in done it will create the .sql file?
I prefer this to be a desktop application.
Thanks
 

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


Re: [PHP-DB] MySQL software question

2004-07-28 Thread dpgirago
I have ERwin 4.1.2208 installed, and it connects to MySQL only through 
ODBC, so one needs to have the MyODBC.dll installed. You can then make an 
ODBC connection with it. But ERwin is probably a $4,000.00 software 
package. Pretty steep for an individual...

dave 

 May be ERwin or BPwin can help you.
 imho ERwin works with MSSQL, Access, so maybe new versions work with 
 MySQL too.
 Vincent Jordan wrote:

 Is there a piece of software that will allow my to create MySQL
 databases and table relations in a graphical format without having to
 connect to the database?
 
 I am looking for something where I can point and click the creation 
of
 tables and easily create several relationships between tables ( kinda
 like in access ) and when in done it will create the .sql file?

RE: [PHP-DB] MySQL software question

2004-07-28 Thread Gilmore, Corey (DPC)
I've used ERWin recently with MySQL 4.1.x and it works well.  It's
fairly expensive, but they do have demo versions available.  As with any
WYSIWYG program you'll probably want to clean up the final product
before using it. 

 -Original Message-
 From: Mikhail U. Petrov [mailto:[EMAIL PROTECTED] 
 Sent: Wednesday, July 28, 2004 7:39 AM
 To: [EMAIL PROTECTED]
 Subject: Re: [PHP-DB] MySQL software question
 
 
 May be ERwin or BPwin can help you.
 imho ERwin works with MSSQL, Access, so maybe new versions 
 work with MySQL too.
 Vincent Jordan wrote:
 
 Is there a piece of software that will allow my to create MySQL 
 databases and table relations in a graphical format without 
 having to 
 connect to the database?
  
 I am looking for something where I can point and click the 
 creation 
 of tables and easily create several relationships between tables ( 
 kinda like in access ) and when in done it will create the .sql file?
  
 I prefer this to be a desktop application.
  
  
 Thanks
 
   
 
 
 --
 PHP Database Mailing List (http://www.php.net/) To 
 unsubscribe, visit: http://www.php.net/unsub.php
 
 
 

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP-DB] MySQL software question

2004-07-28 Thread Rory McKinley
Vincent Jordan wrote:
Is there a piece of software that will allow my to create MySQL
databases and table relations in a graphical format without having to
connect to the database?
 

snip
Try DB Designer from Fabforce - it has it's idiosyncracies, but it is 
free, and I use it without major problems.

HTH
--
Rory McKinley
Nebula Solutions
+27 21 555 3227 - office
+27 21 551 0676 - fax
+27 82 857 2391 - mobile
www.nebula.co.za

This e-mail is intended only for the person to whom it is addressed and
may contain confidential information which may be legally privileged.
Nebula Solutions accepts no liability for any loss, expense or damage
arising from this e-mail and/or any attachments.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php