Tell me more ×
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. It's 100% free, no registration required.
up vote 0 down vote favorite

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
Have you looked at the Migration assistant that Microsoft has? – mrdenny♦ Mar 18 at 14:22

marked as duplicate by JNK♦ Mar 18 at 15:45

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

1 Answer

up vote -1 down vote

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 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 at 14:27
SELECT INTO - stackoverflow.com/questions/4101739/… – dewet Mar 18 at 15:58
An exception is probably result of wrong syntax. Have a look on stackoverflow.com/questions/4091960/… – dewet Mar 18 at 16:00

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