May 7, 2010 at 1:06 am
Hi Greetings,
I need to integrate oracle tables with sql server 2005 tables. Updates must be done on schedule basis from oracle to seq server 2005. what are the possible ways and were can I get details about that? could any one help me out?
Thanks
Vallu
May 7, 2010 at 1:42 am
Please be more specific about what you mean by 'integrate'.
Can the SQL Server data be updated by anything else?
Is there are date/time last updated field on the Oracle tables?
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
May 7, 2010 at 4:25 am
Hi Phil Parkin,
As a part of my work, I have to pull data from oracle database and insert or update them into the Sql Server 2005 Database. This as to be done based on schedules. I want to use few columns of data from Oracle db tables not the whole table's data. This is my basic task.
Now my query is: How to link with Oracle which is on a different server with Sql Server 2005?
what process shell I use to pull data on a regular basis from oracle to sql server 2005?
Options like linkedservice, SSIS, DTS etc what I have to use and which one is the best?
Thanks
Vallu
May 7, 2010 at 4:31 am
This is an SSIS forum, so you won't be surprised that that is what I would recommend 🙂
DTS is the SQL Server 2000 version of SSIS and is therefore old technology. I don't know what you mean by 'linkedservice'.
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply