Export from Oracle

[omarmtz]

Anyone knows if Oracle has a tool for exporting to other databases, for example SQL Server, and that this tool can be scheduling??

It's like the SQL Server's DTS Tasks... Is there something in Oracle like that??

Thanks!

 

[did02]

Hi,

As far as I know, you can install heterogeneous services on your oracle server to be able to create a DBLink between your oracle DB and another DB (not oracle).

But I think it's easier to generate flat files (spooled queries) and load them in your SQL Server DB.

Hope it's help.
Rgds,
Did02

 

[nread]

You could also use the open query function in sql server

 

[omarmtz]

I was thinking in the generation of flat files with the results of queryes from Oracle, and in SQL Server upload these, but i will require two scheduled services, one in Oracle for download, and one in SQL Server for upload, but the problem will be the syncronization, i should organize the times for trigger the events, because the connection will not be direct. If there's no other option, this will be the choice...

How does it work this open query function??? SQL Server extracts the data??, i tell this because, in this case, SQL Server can't see the Oracle Server, only Oracle Server see the SQL server.

 

[nread]

You need to add a Linked Server (Should be under sercurity folder)

Once you have done this you can

INSERT INTO TABLE <Your SQL Table> (field1,field2 etc....)
SELECT *
FROM OPENQUERY(<Your Oracle DB>,'select * from your <OracleDB>')

Hope this helps.....