Data migration from Oracle to SQL server 2005
-
Hi, AS the subject line states, currently it is being done by a third party company, they run scripts to do this. These scripts are set up to run every 3 minutes. We are trying to rewrite this locally. Would SSIS be a way to handle this? Any other way? if anyone could point in the right direction, also where to start with SSIS, I have used DTS Packages before. I opened SSIS and looks pretty overwhelming! Thanks a lot!
-
Hi, AS the subject line states, currently it is being done by a third party company, they run scripts to do this. These scripts are set up to run every 3 minutes. We are trying to rewrite this locally. Would SSIS be a way to handle this? Any other way? if anyone could point in the right direction, also where to start with SSIS, I have used DTS Packages before. I opened SSIS and looks pretty overwhelming! Thanks a lot!
-
Hi, AS the subject line states, currently it is being done by a third party company, they run scripts to do this. These scripts are set up to run every 3 minutes. We are trying to rewrite this locally. Would SSIS be a way to handle this? Any other way? if anyone could point in the right direction, also where to start with SSIS, I have used DTS Packages before. I opened SSIS and looks pretty overwhelming! Thanks a lot!
vanikanc wrote:
Any other way?
You could do it is a OS shell script. Just export from Oracle and import to SQL server, with some post processing via procs in SQL Server if needed. Or write your own service of course. C#, Java, etc. In the past I have not been impressed with SSIS error handling. But I am also very familiar with writing C#/Java database code so I am biased.
-
Hi, AS the subject line states, currently it is being done by a third party company, they run scripts to do this. These scripts are set up to run every 3 minutes. We are trying to rewrite this locally. Would SSIS be a way to handle this? Any other way? if anyone could point in the right direction, also where to start with SSIS, I have used DTS Packages before. I opened SSIS and looks pretty overwhelming! Thanks a lot!
-
I've also had good luck with setting up linked servers from SQL Server to both Oracle and DB2. See here for example - http://www.ideaexcursion.com/2009/01/05/connecting-to-oracle-from-sql-server/[^] Scott
SSIS is the best choice for a tool candidate that will be used for data transfer But you can create a SP and create a job with 3 minutes interval in each run Within the SP you can connect to Oracle DB and transfer your data using stored procedure.