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

i used Oracle's Migration tool to convert SQL*Server to Oracle/NT. at least, the conversion was running when i left work. it seemed to be working ok.

does anyone have some experience/advice on Oracle's Migration Workbench vs the other tools mentioned in this thread.

ron....

stef ten bras <stbras_at_hiscom.nl> wrote in message news:85vdhd$d7u$1_at_porthos.nl.uu.net...
> 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 Tue Jan 18 2000 - 00:00:00 CET