Home » RDBMS Server » Networking and Gateways » Data Transfer from SQL Server to Oracle
Data Transfer from SQL Server to Oracle [message #376934] Fri, 19 December 2008 03:53 Go to next message
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
Re: Data Transfer from SQL Server to Oracle [message #376935 is a reply to message #376934] Fri, 19 December 2008 03:57 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
ODBC will always be slow. Use Oracle's Transparent Gateway instead.
Re: Data Transfer from SQL Server to Oracle [message #376986 is a reply to message #376935] Fri, 19 December 2008 05:59 Go to previous messageGo to next message
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.
Re: Data Transfer from SQL Server to Oracle [message #376987 is a reply to message #376935] Fri, 19 December 2008 06:03 Go to previous messageGo to next message
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
Re: Data Transfer from SQL Server to Oracle [message #376991 is a reply to message #376987] Fri, 19 December 2008 06:14 Go to previous message
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.
Previous Topic: unable to connect TNS name problem.
Next Topic: Oracle 10 g client networking issue
Goto Forum:
  


Current Time: Tue Dec 06 16:25:19 CST 2016

Total time taken to generate the page: 0.05772 seconds