RE: Migrating SQL Server stored procedures to Oracle

Woody,

One of my coworkers, Michael Rothouse, did a migration study from SQL Server to Oracle. He pitched his paper at the 99 Openworld. You can get to his papers via IOUG, or http://www.ioug.org/repository/index.html, and look for his name.

If you don't have access to IOUG then holler back at me and I will forward your request to him.

hth.

Chris Grabowy
"May Oracle be with you...always"

-----Original Message-----
From: Igor Neyman [mailto:ineyman_at_perceptron.com] Sent: Friday, August 04, 2000 3:14 PM
To: Multiple recipients of list ORACLE-L Subject: Re: Migrating SQL Server stored procedures to Oracle

Oracle has Migration Kit (SQL Server -> Oracle), which does ~80% of the work automatically (at least that's what they say). I think it depends on complexity of your stored procedures and usage of SQL Server custom features..

Igor Neyman, OCP DBA
Perceptron, Inc.
(734)414-4627
ineyman_at_perceptron.com

• Original Message ----- To: <oracledba_at_quickdoc.co.uk>; <ORACLE-L_at_fatcity.com>; <oracledba_at_lazydba.com> Sent: Friday, August 04, 2000 12:14 PM

> Hello all,
>
> Does anyone have any tools, tips, advice, etc. for migrating stored
> procedures from SQL Server 7 to Oracle 8.1.5?
> I hate typing...
>
> Thanks,
>
> Woody
>
>
> --------
> If you're bored, then visit the list's website: http://www.lazydba.com
(updated daily)
> to unsubscribe, send a blank email to oracledba-unsubscribe_at_quickdoc.co.uk
> to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk
>

-- 
Author: Igor Neyman
  INET: ineyman_at_perceptron.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).