Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

This question already has an answer here:

I have an Oracle database in a remote server. I want to import data from it to SQL Server on a local machine using a stored procedure or job shedule but I don't know how can I do it.

share|improve this question

marked as duplicate by JNK Mar 18 '13 at 15:45

This question was marked as an exact duplicate of an existing question.

Have you looked at the Migration assistant that Microsoft has? – mrdenny Mar 18 '13 at 14:22

Here you have nice article how to link oracle to your SQL Server and query it.

For data import you can you SELECT INTO statement or make SSIS package for that.

share|improve this answer
plz can you tell me how can I import data with the Select Statement? thank you so much :) – amalch Mar 18 '13 at 14:20
when i try to use link oracle to sql i obtain this error: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) help plz – amalch Mar 18 '13 at 14:27
SELECT INTO -… – dewet Mar 18 '13 at 15:58
An exception is probably result of wrong syntax. Have a look on… – dewet Mar 18 '13 at 16:00

Not the answer you're looking for? Browse other questions tagged or ask your own question.