Re: One design for different DBMSs

> Any sources of information and/or tools for designing relational
> databases for different platforms (Oracle, DB2, Sybase etc)? Logical
> design (tables etc) is always the same, but the implementation is done
> in different DBMSs.

I'm not sure what you are asking about. There are CASE tools that separate out logical design
from physical design.

For example, Power Designer from Sybase allows you to construct one "Conceptual Data Model" (CDM)
where you capture the requirements at the conceptual level. You can then use the CDM to construct a
"physical data model" PDM (or several of them). When you construct a PDM you specify a database product, and some other details that are deliberately omitted from the CDM.

Is this an example of what you were asking about?

--
Regards,
    David Cressey
    www.dcressey.com
"Matti Teppo" <matti.teppo_at_nospam.deio.net> wrote in message
news:3B693422.560A8A3C_at_nospam.deio.net...


>

> Or is maintaining a separate design for every DBMS the only way?


>

> Thanks,

>

> Matti

>