Re: Migration Project: MSSQL to Oracle

From: Tim Gorman <tim_at_evdbt.com>
Date: Sun, 11 May 2014 17:30:30 -0600
Message-ID: <53700815.6050004_at_evdbt.com>

Oracle Gateway for SQL Server is a standard part of Oracle Database, downloaded as one of the seven download files. Installation and deployment is quite easy, and I don't believe there is any additional license cost; of course you'll want to check that to be certain.

The gateway allows you to query tables in SQL Server over Oracle database links.

On 5/11/2014 4:59 PM, Nik Tek wrote:
> Hi Bobby,
>
> I'm not familiar with Oracle GoldenGate, and I'm not sure it is free
> to use it.
>
> The requirement is tool should be completely free.
>
> Thank you
> Raju
>
>
> On Sun, May 11, 2014 at 1:35 PM, Bobby Curtis - ACE
> <curtisbl_at_gmail.com <mailto:curtisbl_at_gmail.com>> wrote:
>
> Are you looking to write a tool to do the migration? Are you
> prohibited from using Oracle GoldenGate? There are tools that are
> designed to this already, please explain in more detail why you
> want to write a new tool.
>
> Thanks
>
> Bobby
>
> *From:*oracle-l-bounce_at_freelists.org
> <mailto:oracle-l-bounce_at_freelists.org>
> [mailto:oracle-l-bounce_at_freelists.org
> <mailto:oracle-l-bounce_at_freelists.org>] *On Behalf Of *Nik Tek
> *Sent:* Sunday, May 11, 2014 4:16 PM
> *To:* ORACLE-L
> *Subject:* Migration Project: MSSQL to Oracle
>
> 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 - 01:30:30 CEST