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.

  • Have you looked at the Migration assistant that Microsoft has?
    – mrdenny
    Mar 18, 2013 at 14:22

1 Answer 1


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.

  • plz can you tell me how can I import data with the Select Statement? thank you so much :)
    – amalch
    Mar 18, 2013 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, 2013 at 14:27
  • SELECT INTO - stackoverflow.com/questions/4101739/…
    – dewet
    Mar 18, 2013 at 15:58
  • An exception is probably result of wrong syntax. Have a look on stackoverflow.com/questions/4091960/…
    – dewet
    Mar 18, 2013 at 16:00

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