General information
Forum:
Microsoft SQL Server
Title:
Data modeling tool for both SQL server and 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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only