Fred Read wrote:
>
> Jay Miller wrote:
> >
> > I do not know of a tool to draw an ER diagram. If you converted
> > MySQL "Create Table" scripts to Access, you still wouldn't have
> > foreign key information, so you would have to manually specify
> > the relationships in Access.
>
> Our "Create Table" scripts *do* contain foreign key information.
> So, if we had a simple means of converting the SQL to Access we
> could produce the ER diagram from there with next to no effort...
>
> Anyone know of such a tool ? [Access 2 or 97.]
> --
You may finish a Perl script that will convert your
syntax into whatever format you need before you find and
install the tool that could do it.
--
Sasha Pachev
http://www.sashanet.com/ (home)
http://www.direct1.com/ (work)