Connect Oracle to SQL Server Database

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Administration

Connect Oracle to SQL Server Database

Author

Topic

shari
Starting Member

2 Posts

Posted - 2010-02-18 : 11:42:00

Friends -

Could you please advise how to connect oracle database to SQL Server database.

Is there any microsoft article with step by step

Please advise

Regards
SHARI

Kristen
Test

22859 Posts

Posted - 2010-02-18 : 12:20:21

Do you want to:

1) Oracle to be able to "see" data in SQL Server
2) SQL Server to be able to "see" data in Oracle
3) Just Xfer data between the two - so there is a local copy at both ends
4) Something else?

shari
Starting Member

2 Posts

Posted - 2010-02-18 : 12:23:52

Thank you Kristen for reply.

I am looking for option :1

Oracle to be able to "see" data in SQL Server

Regars
Shari

Kristen
Test

22859 Posts

Posted - 2010-02-18 : 12:35:06

Ah ... that's the only one I don't know how to do - sorry!

mahajanakhil1985
Yak Posting Veteran

71 Posts

Posted - 2010-02-18 : 13:45:27

I am an oracle guy. So I have a suggestion. Export SQL Server data to a flat file and then use something called external tables to read this data. If you want to import data to Oracle DB, use SQL Loader. If you want to import some data from multiple tables of SQL Server, then use join and create such a table, sump this table to flat file and then use external table.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources