Am trying to find a modelling tool that will reverse engineer an
ingres v2 database. I am aware that CA have a product called 'ERWin',
but this does not support ingres. Any suggestions (apart from change
DBMS's ).

Thanks.

"Guy Underhill" <guy.underhill@molevalley.gov.uk> wrote in message
news:c3486120.0309110550.4a9e55a7@posting.google.c om...
> Am trying to find a modelling tool that will reverse engineer an
> ingres v2 database. I am aware that CA have a product called 'ERWin',
> but this does not support ingres. Any suggestions (apart from change
> DBMS's ).

Visio can certainly reverse-engineer Ingres databases just fine using ODBC.
I do it all the time. I would be staggered if ERwin couldn't do the same.
And does ERwin really not support Ingres?! I thought it did, even years
ago, albeit by digesting unloaddb scripts.

For a walk-through of using Visio against Ingres via ODBC, take a look at
the presentation "Ingres is Open for Business", written by Wojtek Rappak,
and available for download from our website at www.rationalcommerce.com,
under the Resources and White Papers link. If you have PK and FK
constraints defined in your Ingres DB, Visio will draw the entire diagram
for you.

Amongst other things, that presentation aims to debunk the idea that you
always need DBMS-specific drivers. There may be a few things that require a
product-specific driver, but 95% of what most folk want to do is easily
handled by ODBC--after all, DBMS independence and open connectivity was the
whole point of it.

HTH.

Roy Hann (rhann at rationalcommerce dot com)
Rational Commerce Ltd.
www.rationalcommerce.com
"Ingres development, tuning, and training experts"

The latest AllFusion Erwin Data Modeller leaflet show the following
supported environments (which include Ingres).

<QUOTE>
Supported Environments

Platforms:
• Windows 95, 98, 2000, NT 4.0, XP

Databases:
Advantage™ Ingres® Enterprise Relational Database, Advantage™
CA-Clipper,® DB2, dBASE, FoxPro, HiRDB, Informix, InterBase,
Microsoft Access, Teradata, Microsoft SQL Server, ODBC 2.0, 3.0,
Oracle, Paradox, Rdb, Red Brick Warehouse, SAS, SQL Anywhere,
SQL Base and Sybase.
</QUOTE>

Whether the relationships between the tables can be inferred
automatically will depend on the naming convention used.

Hope this helps,
Chris Dawe

On 11 Sep 2003 06:50:32 -0700, guy.underhill@molevalley.gov.uk (Guy
Underhill) wrote:

>Am trying to find a modelling tool that will reverse engineer an
>ingres v2 database. I am aware that CA have a product called 'ERWin',
>but this does not support ingres. Any suggestions (apart from change
>DBMS's ).
>
>Thanks.

--
Ingres Consultant
cedawe@bcs.org.uk

"Chris Dawe" <chris.dawe@labyrinthdata.co.uk> wrote in message
news:ml12mv46m8vbalfs5mnlhvu36q3ig2r1jr@4ax.com...

> Whether the relationships between the tables can be inferred
> automatically will depend on the naming convention used.

You are kidding, right?

Roy

"Roy Hann" <rhann@globalnet.co.uk> wrote in message news:<bjrodk$92j$1@hercules.btinternet.com>...
> "Chris Dawe" <chris.dawe@labyrinthdata.co.uk> wrote in message
> news:ml12mv46m8vbalfs5mnlhvu36q3ig2r1jr@4ax.com...
>
> > Whether the relationships between the tables can be inferred
> > automatically will depend on the naming convention used.
>
> You are kidding, right?
>
> Roy

ERWin does support reverse engineering from Ingres, either directly
from the database (via ODBC) or from an unloaddb file. There are two
options for deriving the relationships : either through indexes and
constraints (as per Visio), or working it out from column names as
Chris said.

Dave