Re: One design for different DBMSs

Matti Teppo <matti.teppo_at_nospam.deio.net> wrote in message news:<3B693422.560A8A3C_at_nospam.deio.net>...
> 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.
>
> Or is maintaining a separate design for every DBMS the only way?
>
> Thanks,
>
> Matti

If you use a tool such as Embarcadero Technologies ER/Studio, then it's a no brainer. It allows you to develop logical models in either Sybase, Oracle, MSSQLServer and DB2, then deploy them automatically in any of the others. Highly recommended.

Joe Trubisz
Dept. of Computer Science
SUNY Stony Brook
Stony Brook, NY 11794 Received on Sat Aug 11 2001 - 23:49:00 CEST