Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Migrating from MS Sql Server to Oracle
"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