RE: Migration Project: MSSQL to Oracle

Good point, I didn’t think about the SQL Server Gateway. That should solve the “needs to be free” concerns.  

Bobby  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Tim Gorman Sent: Sunday, May 11, 2014 7:31 PM
To: oracle-l_at_freelists.org
Subject: Re: Migration Project: MSSQL to Oracle  

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