Trying to implement our database (SQL-server) in ORACLE.

For our product we will be supporting two databases.

MS-SQLserver and ORACLE.

The database was build in MS-SQLserver, mainly using the SQL Server Enterprise Manager.

At the moment we are evaluating DBArtisan from Embarcadero (http://www.embarcadero.co.uk), to get the tables from SQL-server towards ORACLE.

We have transported our tables, indexes and constraints. But up to now we haven't been able to transport our :

Views.

And also not the diagrams, stored procedures and triggers.
(But these are all less inportant than the views).

Does anybody have a workable way to transport the views from SQL-server to ORACLE.
(Most problems stem for joins (outerjoins specificaly)).
If there is a solution for transporting from ORACLE to SQL-server, then we might consider this for the future.

We wil be continueing with both products and would like to have a procedure / tool to transport the metadata etc. from one to another. Doing the maintanance on both databases, makes it more funarable to mistakes.
Doing the conversion of views by hand is very errorprone.

Thanks,

stef ten bras, Received on Mon Jan 17 2000 - 00:00:00 CET