You might try contacting David Hay at
http://www.essentialstrategies.com/ He is an expert at data modeling and did extensive DM while working for Oracle.
>We are developping a system that has to be deployed on both Sql Server or Oracle (depending on clients).
>
>Since the initial release was in SQL Server, DB design was done directly in SEM. I used UDT, UDF, SP. The application only has access to SP, so no SQL statement (DML) is launched directly from application.
>
>So far so good.
>
>Now I used ERWIN to reverse engineer from physical model to logical. To goal is to be able to forward toward Oracle. Since Oracle and SQL server are different, I am faced with some conversion consideration.
>
>Exemple:
>
>1- IDENTITY column are handled with sequences and triggers in Oracle.
>
>2- UDT exists in Oracle, but the implementation is different (no default value in Oracle)
>
>3- SP: Tsql and PL-SQL are different..
>
>
>TO your knowledge, is there a tool that would be able to have a common logical definition of my model (including pk generation (identity vs sequences), udt and procedures), that could do the physical generation (tables, pk, udt, procs) in both Oracle and Sql Server.
>
>If not, I'm faced with the duplication of my effort, and that's bad!
>
>Thanks for your appreciated inputs.
>
>P.S. posted in both Sql Server and Oracle Forums
Mark McCasland
Midlothian, TX USA