Re: Tool to migrate from Microsoft SQLServer to Oracle
Date: Tue, 18 Mar 2003 13:50:50 -0800
Message-ID: <3E7794BA.70CE4B5D_at_exxesolutions.com>
Vivek Chaudhary wrote:
> We are in the process of migrating from Microsoft SQLServer to Oracle.
> Oracle's migration bench utility works for most part. But it does not
> convert stored procedures properly and for now I have to manually
> correct migrated stored procedures. I am looking for way(s)/tool(s) to
> migrate to Oracle seemlessly.
Not only does no tool do this well no tool written will ever do this well.
The basic underlying architectures of Oracle and SQL Server are completely different. You can not write a tool to handle the differences in concurrency or transaction models or locking or temp table usage, etc. No tool capable of moving from a model with only AFTER triggers to one with BEFORE and AFTER.
You need to go to http://tahiti.oracle.com and read the Concepts and
Architecture documents
You need to buy Tom Kyte's book "Expert one-on-one Oracle"
And you need to stop working until you have because otherwise you are just
wasting your time.
Don't mean to be harsh or negative ... it is just the nature of the beast.
Daniel Morgan Received on Tue Mar 18 2003 - 22:50:50 CET