Re: Migration Project: MSSQL to Oracle
Date: Sun, 11 May 2014 19:45:23 -0600
Message-ID: <537027B3.6070607_at_gmail.com>
Based on experience and verified by
http://www.oracle.com/us/corporate/pricing/technology-price-list-070617.pdf, Oracle's price list, the "Transparent Gateways" are licensed and have a price tag.
The Heterogeneous Services (Formerly Transparent Gateway for OBDC, and
now Database Gateway for ODBC) is included in the DB license according
to
http://docs.oracle.com/cd/E16655_01/license.121/e17614/editions.htm#DBLIC125
and
http://docs.oracle.com/cd/E11882_01/license.112/e47877/editions.htm#DBLIC123
Decent information on config and use at http://docs.oracle.com/cd/E16655_01/server.121/e17907/toc.htm (Oracle® Database Heterogeneous Connectivity User's Guide for 12c Release 1 (12.1))
That, plus a set of good scripts (in PL/SQL) can go a long way to helping the OP, if he's interested in learning about it.
/Hans
On 11/05/2014 5:30 PM, Tim Gorman wrote:
> 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-lReceived on Mon May 12 2014 - 03:45:23 CEST