Thread: Database reverse engineering
<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>
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
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
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