OraFAQ Forum: Server Utilities » What is the best tool to export data from an Oracle database into a SQL database?

Home » RDBMS Server » Server Utilities » What is the best tool to export data from an Oracle database into a SQL database?

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

What is the best tool to export data from an Oracle database into a SQL database? [message #68988]

Wed, 10 October 2001 06:47

Suzanne
Messages: 2
Registered: July 2000

Junior Member

Hello,
Can someone tell me, what is the best tool/method to
export data from an Oracle based database into a SQL database?
Thanks in advance.

Regards.
Suzanne

----------------------------------------------------------------------

Report message to a moderator

Re: What is the best tool to export data from an Oracle database into a SQL database? [message #68989 is a reply to message #68988]

Wed, 10 October 2001 07:19

Chella
Messages: 25
Registered: September 2000

Junior Member

Hi,

I use the SPOOL command to export Oracle data to Excel. You can investigate more according to your requirements. HTH

Chella

----------------------------------------------------------------------

Report message to a moderator

Re: What is the best tool to export data from an Oracle database into a SQL database? [message #69000 is a reply to message #68988]

Fri, 12 October 2001 07:29

Jonas
Messages: 6
Registered: February 2001

Junior Member

Hi there Suzanne.

It depends on how much data we are talking about.
If there is not to much data a nice way is to set up an Transparent gateway and link tables then just do a insert into sql.table select * from oracle.table. I haven't tried this but i think it should work.

----------------------------------------------------------------------

Report message to a moderator

Re: What is the best tool to export data from an Oracle database into a SQL database? [message #69287 is a reply to message #68988]

Tue, 04 December 2001 05:15

SunilK
Messages: 2
Registered: December 2001

Junior Member

I've used SQL Servers data transformation stuff it works pretty well

----------------------------------------------------------------------

Report message to a moderator

Previous Topic:	Re: How to exporting DB oracle to SQl server ..
Next Topic:	update data using sql loader

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 15 10:27:18 CDT 2026