I'd be happy if someone could help me. I need to get data from PL sql developer oracle and import of sql server, I want to do automatic synchronization. now I am exporting an Excel file from PL sql developer oracle, and load the file into sql server
Asked
Active
Viewed 107 times
-1
-
1We will be happy to help! What problems have you encountered? – Tomasz Plaskota Dec 08 '16 at 11:18
-
I want to know what's the best way to do this? Any suggestions ? – רון כהן Dec 08 '16 at 14:17
1 Answers
0
The tool specifically built for this is Sql Server Integration Services (SSIS). You can create a data flow with source component using Oracle Driver and destination using Sql Server. You can even add transforms between the two to handle formatting and other tasks.
Here is a link to a series of videos on the topic. There is plenty of non - video materials as well if you prefer.
Joe C
- 3,925
- 2
- 11
- 31