Re: Migration Project: MSSQL to Oracle

From: Ls Cheng <exriscer_at_gmail.com>
Date: Mon, 12 May 2014 12:37:46 +0200
Message-ID: <CAJ2-Qb9q2aL+O-W75=moq0fhFkYz_LGzNJbvESrVV0ntJ6MKNA_at_mail.gmail.com>

I saw this product a couple of months ago, havent tried it myself but I think Mark Bobak was testing it, or I saw some blog post from him.

http://www.dbvisit.com/products/dbvisit_replicate_real_time_oracle_database_replication/#features

You can even rent it for a few months (not like GoldenGate which you need to buy perpertual license) during your migration and the price is decent, may be worth a look.

Thanks

On Sun, May 11, 2014 at 10:16 PM, Nik Tek <niktek2005_at_gmail.com> wrote:

> Hi,
>
> I have a question about migrating data from MSSQL and Oracle.
>
> I'm working on a migration project from MSSQL and Oracle.
>
> I have around 1040 tables on source (MSSQL) side, database size could be
> around 100-300 GB.
>
> I would have to do this operation repeatedly, so I'm thinking of creating
> it as a tool (command line based).
>
> Could anyone give me some guidelines on how to achieve it.
>
> * I have already created the destination schema on Oracle(Converted all
> SPs, Triggers, Tables, Views, Functions to pl/sql compatibility). I have to
> migrate data ONLY between source and destination databases.
>
> Source: MS SQL 2008 R2
> Destination: Oracle11g R2
>
> I have used Oracle's SQL Developer Migration Tool, but I'm not sure if I
> can bundle it as part of my software, as this tool is going to be free to
> the community.
>
> Thank you
> NikTekki
>

--
http://www.freelists.org/webpage/oracle-l

Received on Mon May 12 2014 - 12:37:46 CEST