DA Morgan wrote:
> Vince <vincent@ wrote:
>
>> Hi there!
>>
>> I have some trSQL procedures to rewrite in PLSQL, is there any way to
>> convert transactSQL code to PLSQL code...freewares..links...
>> Anymay, what is the similar oracle exe for 'osql' of SQLServer, in
>> order to insert by command shell SQL code ?
>>
>> Thanks a lot :)
>> ++
>> Vince
>
>
> Not that you would want to use. There is a migration workbench from
> Oracle but what it writes will at best be syntactically correct: It
> will not be good code.
>
> The most important consideration here should be that you would not
> want to just rewrite ... when you need to rearchitect. For example
> in Oracle one can, but never, uses temp tables. You are moving to
> an architecture where reads don't block writes and writes don't block
> reads and things work differently.
>
> Get a copy of Tom Kyte's book Expert one-on-one Oracle, read it cover
> to cover but pay special attention to the first three chapters. It is
> going to be a far happier experience if you understand Oracle, make a
> few changes to the schema, and then code appropriately.
I can only agree with that - from experience!
--
Regards,
Frank van Bortel
Received on Sat Apr 30 2005 - 06:52:18 CDT