Re: One design for different DBMSs

I purchased PD for my company. I create logical and physiacl models for both Oracle and SQL Server. I don't need alot of fine tuning on the generated ddl, but I have found a few bugs in the features. Sybase has been generally responsive (albeit slow) to reports of problems with the software. We created database definition files for SQL Server and Oracle (it is in XML) to generate DDL that fits our source templates, which I think is a nice feature. The interface can be a little quirky, but is pretty easy to use. All the major DBMS are supported in one license.

It's a decent tool, but I can say I would look at Erwin 4, and compare the SQL Server support if I were purchasing again. We eval'd ERStudio, but at that time it did not support SQL 2000.

Hope that helps,

--
Carl T. Demelo
Senior DBA
Transcore

"Matti Teppo" <matti.teppo_at_nospam.deio.net> wrote in message
news:3B70DA83.4B5A93FA_at_nospam.deio.net...


> > I'm using Power Designer V8 for SQL Server and Oracle designs.


>

> Is this what comes with Sybase ASE, or is Sybase shipping a limited

 version


> only?


>

> By using Power Designer, are you able to produce a good physical model for

 both


> platforms, or do you need to manually fine-tune the DDL a lot?


>

> Thank you,

>

> Matti

>

>