June 21, 2016 at 8:19 am
Hi Folks,
I have a requirement for a table refresh (truncate/load) that needs to happen daily from Oracle to SQL. The table is relatively small. What is the best approach or options to accomplish this.
* Use linked server/SQL agent job for automation? Anyone can Provide a steps/script for this.
* Use a view in SQL server db to point to Oracle data?
* SSIS package?
* any other?
Many thanks in advance
June 21, 2016 at 9:01 am
SQL!$@w$0ME (6/21/2016)
Hi Folks,I have a requirement for a table refresh (truncate/load) that needs to happen daily from Oracle to SQL. The table is relatively small. What is the best approach or options to accomplish this.
* Use linked server/SQL agent job for automation? Anyone can Provide a steps/script for this.
* Use a view in SQL server db to point to Oracle data?
* SSIS package?
* any other?
Many thanks in advance
I think you'll find that different people prefer different ways of doing this. Personally, for data movement across heterogenous platforms, I'd choose SSIS almost every time. It also has the advantage, in this situation, of minimising 'coupling' between your SQL Server and Oracle databases.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
June 21, 2016 at 9:08 am
I too vote for SSIS.
Regards
Durai Nagarajan
June 21, 2016 at 10:39 am
It depends on the Oracle driver used by SSIS. I had the bad experience on having a very slow one.
A faster option was to export to a flat file and import the file with bulk insert or SSIS.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply