OraFAQ Forum: Networking and Gateways » Data Transfer from SQL Server to Oracle

Home » RDBMS Server » Networking and Gateways » Data Transfer from SQL Server to Oracle

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Data Transfer from SQL Server to Oracle [message #376934]

Fri, 19 December 2008 03:53

vishal gupta
Messages: 111
Registered: March 2001

Senior Member

Hi,
I am transferring data from Sql Server 2000 to Oracle 9i using Heterogenous services(ODBC).
One of the table has 2 billion records.
What is the best startegy to transfer this much data efficiently?
Is the CTAS best option?

regards

Report message to a moderator

Re: Data Transfer from SQL Server to Oracle [message #376935 is a reply to message #376934]

Fri, 19 December 2008 03:57

Frank Naude
Messages: 4581
Registered: April 1998

Senior Member

ODBC will always be slow. Use Oracle's Transparent Gateway instead.

Report message to a moderator

Re: Data Transfer from SQL Server to Oracle [message #376986 is a reply to message #376935]

Fri, 19 December 2008 05:59

tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden

Senior Member

Depends I guess.

Are you doing this once or is it's something that you want to do on regular basis ?

Since the Transparent Gateway requires a seperate license.

Report message to a moderator

Re: Data Transfer from SQL Server to Oracle [message #376987 is a reply to message #376935]

Fri, 19 December 2008 06:03

vishal gupta
Messages: 111
Registered: March 2001

Senior Member

Hi,
I will be doing it once only.
This is historical data (3 months)
I cannot use Transparent gateways as you said that it requires a seperate license.

Regards

Report message to a moderator

Re: Data Transfer from SQL Server to Oracle [message #376991 is a reply to message #376987]

Fri, 19 December 2008 06:14

tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden

Senior Member

Have a look at the Oracle Migration Workbench then.(which is free)

Or export the rows to a flatfile, and you use SQL*Loader to load it into Oracle.

Report message to a moderator

Previous Topic:	unable to connect TNS name problem.
Next Topic:	Oracle 10 g client networking issue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 22:32:29 CST 2024