Take the 2-minute tour ×
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.

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 '13 at 14:22
add comment

marked as duplicate by JNK Mar 18 '13 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

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

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