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

And how was/is the conversion finished ?

Where VIEWS included in the converstion ?

stef,

Ron McCamish wrote in message
<3bQg4.6780$%%6.111923_at_typhoon.columbus.rr.com>...
>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 Thu Jan 20 2000 - 00:00:00 CET