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

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 Go to previous messageGo to next message
Frank Naude
Messages: 4596
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 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.

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 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

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 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.

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 17 09:25:55 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.