Thread: Database reverse engineering

Database reverse engineering

From
"Oleg I.Ivanov"
Date:
<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-US" style="font-size:
10.0pt;font-family:Arial">Excuse me for a possible offtopic,</span></font><p class="MsoNormal"><font color="navy"
face="Arial"size="2"><span lang="EN-US" style="font-size:10.0pt;font-family:Arial;color:navy">b</span></font><font
face="Arial"size="2"><span lang="EN-US" style="font-size:10.0pt;font-family:Arial">ut can anybody help me to understand
whySybase Power Designer 10.1 does not understand serials and inheritance when reverse engineer Postgres database from
script.</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span lang="EN-US" style="font-size: 
10.0pt;font-family:Arial">Is it possible to teach PowerDesigner to reverse engineer correctly ?</span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span lang="EN-US" style="font-size: 
10.0pt;font-family:Arial">Or can anybody recommend me right tool which works correcty?</span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span lang="EN-US" style="font-size: 
10.0pt;font-family:Arial">Thank you,</span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-US"
style="font-size:
10.0pt;font-family:Arial">Oleg</span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-US"
style="font-size:
10.0pt;font-family:Arial"> </span></font></div>

Re: Database reverse engineering

From
Andreas Pflug
Date:
Oleg I.Ivanov wrote:
> Excuse me for a possible offtopic,
> 
> but can anybody help me to understand why Sybase Power Designer 10.1 
> does not understand serials and inheritance when reverse engineer 
> Postgres database from script.

Serial is no datatype, but an int4 with a default. I don't know if the 
default is reverse engineered correctly, I'd recommend to change it 
manually to "serial".

> Is it possible to teach PowerDesigner to reverse engineer correctly ?

Probably not. pgAdmin has special treatment for int4/default to detect a 
serial; PD as cross platform tool is not smart enough.
Similar about inheritance; I don't even know a way how to design this in 
PD (in PD 8.0, I doubt 10.x is better).

> Or can anybody recommend me right tool which works correcty?

You could try ERwin, but I doubt you will be luckier there.

Regards,
Andreas


Re: Database reverse engineering

From
Simon Riggs
Date:
On Fri, 2004-11-12 at 18:16, Andreas Pflug wrote:
> Oleg I.Ivanov wrote:
> > Or can anybody recommend me right tool which works correcty?
> 
> You could try ERwin, but I doubt you will be luckier there.
> 

Hmmm...been fighting with the ERwin/PostgreSQL combination, though it
works well with other databases.

Case Studio looks like it has better support, but I've not had the
opportunity yet to try it yet.
http://www.casestudio.com/enu/databases.aspx

-- 
Best Regards, Simon Riggs



Re: Database reverse engineering

From
Robert Treat
Date:
On Monday 15 November 2004 11:01, Simon Riggs wrote:
> On Fri, 2004-11-12 at 18:16, Andreas Pflug wrote:
> > Oleg I.Ivanov wrote:
> > > Or can anybody recommend me right tool which works correcty?
> >
> > You could try ERwin, but I doubt you will be luckier there.
>
> Hmmm...been fighting with the ERwin/PostgreSQL combination, though it
> works well with other databases.
>
> Case Studio looks like it has better support, but I've not had the
> opportunity yet to try it yet.
> http://www.casestudio.com/enu/databases.aspx

I did the Erwin/PostgreSQL dance for awhile when I first started with my 
present employer as they already had a license.  In order to get it to work I 
would have had to write a set of perl scripts to massage the output, so I 
ditched it instead for Case Studio and haven't looked back.  It's not perfect 
but it is plenty good for even complex schemas; enough so that really my only 
gripe is that it doesn't run on *nix :-(

-- 
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL