Re: Migration Project: MSSQL to Oracle
- From: Nik Tek <niktek2005@xxxxxxxxx>
- To: tim@xxxxxxxxx
- Date: Sun, 11 May 2014 21:19:00 -0700
Hi Tim,
Would dblink work for source database of size 100-300 Gb?
Regards
Nik
On Sun, May 11, 2014 at 4:30 PM, Tim Gorman <tim@xxxxxxxxx> 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@xxxxxxxxx>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@xxxxxxxxxxxxx [mailto:
>> oracle-l-bounce@xxxxxxxxxxxxx] *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
>>
>
>
>
Other related posts:
