Hi Guys,
I would like to start a discussion through my blog to know more about this topic.
Below options I know to import data from Oracle to SQL..
1) Import/Export
2) Linked Server (Using OpenQuery)
3) SSIS Packages
The fastest among these 3 I noticed is the 3rd one and the slowest is the second one. But when we need very frequent refresh between systems using SSIS is not a good idea. Did anyone gone through all these and found the best method..if yes, please explain. Appreciate your response.
I would like to start a discussion through my blog to know more about this topic.
Below options I know to import data from Oracle to SQL..
1) Import/Export
2) Linked Server (Using OpenQuery)
3) SSIS Packages
The fastest among these 3 I noticed is the 3rd one and the slowest is the second one. But when we need very frequent refresh between systems using SSIS is not a good idea. Did anyone gone through all these and found the best method..if yes, please explain. Appreciate your response.
No comments:
Post a Comment