Oracle DB Table to SQL Server DB Table

Question

I am wondering if there is a way to replicate an oracle table over to a sql server table. Both servers are on the same network. I would like to have this automated perhaps using a stored procedure on the sql instance. Is there any way to do this automatically? Or can anyone point me to a good sql script to connect to an oracle db server and export a table file?

Andres · Accepted Answer · 2014-01-29 16:00:00Z

1

You could use an Oracle linked server on SQL-Server. In this way you would use the Oracle data directly from SQL-server.

Take a look at this tutorial: http://blogs.msdn.com/b/dbrowne/archive/2013/10/02/creating-a-linked-server-for-oracle-in-64bit-sql-server.aspx

edited Jan 29, 2014 at 16:00

answered Jan 29, 2014 at 15:53

Andres

10.7k4 gold badges50 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Skunny11 Over a year ago

Thanks, I will take a look at that and get back to you about if it does what I need.

TTeeple · Accepted Answer · 2014-01-29 15:51:23Z

0

You can use the Import Data function located under Tasks when you right click on a database in SQL Server Management Studio. It will walk you through picking the Source, the Destination, and how the columns map to each other.

answered Jan 29, 2014 at 15:51

TTeeple

2,9791 gold badge16 silver badges22 bronze badges

Comments

nestavazquez · Accepted Answer · 2014-01-29 15:53:01Z

0

Look at this:

http://www.microsoft.com/en-us/download/details.aspx?id=28766

Maybe it should help you

answered Jan 29, 2014 at 15:53

nestavazquez

435 bronze badges

Collectives™ on Stack Overflow

Oracle DB Table to SQL Server DB Table

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related