Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Migrating from MS Sql Server to Oracle

Re: Migrating from MS Sql Server to Oracle

From: Greg D. Moore \(Strider\) <mooregr_at_greenms.com>
Date: Tue, 19 Mar 2002 04:02:58 GMT
Message-ID: <SLyl8.144238$V15.24130074@typhoon.nyroc.rr.com>

"Mark Kessler" <mk_at_smartlingua.com> wrote in message news:327aea7c.0203181957.5a56ea55_at_posting.google.com...
> Hello all,
> I am facing the problem of migrating quite a big database (+100 tables
> and stored procedures) from an MS Sql Server to an Oracle 8i Server.
>
> No I am trying to get an estimation of the necessary effort to put
> into this.
>
> Assuming the following situation: Being neither an expert in Ms Sql or
> Oracle but more an advanced user, and only starting to get inside into
> the database I have to migrate..
>
> Would you say that it this possible to accomplish the migration in a
> matter of days or weeks, when using a migration tool like the Oracle
> Migration workbench? Or do I have to expect to put hand on every
> stored procedure manually?

I know nothing about Oracle Migration workbench, but based on prior experience with similar projects I'd say weeks, not days.

I mean you can probably get tables converted fairly quickly and possibly even the stored procs, but then adapting them and tuning them for Oracle will take some time.

>
> I would appreciate any input very much.
>
> Mark Kessler
Received on Mon Mar 18 2002 - 22:02:58 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US