January 28, 2009 at 1:50 am
Hi Guys,
we need to import data from oracle server to SQL server on daily basis.
let me clarify the problem, we have Oracle database on a LIVE system which is being updated with new rows on a very high rate (Its a telecommunication application), so we don't want to query select statements so often to avoid any possible probelm.
We have another database .i.e MS SQL server, we need to import data from Oracle to MS SQL server on daily basis during late night hours when pressure on Oracle is bit reduced.
I need suggestions and comments how best we can do it, I have heard a bit about MSSQL transformation services. Will this help us or any C# program to update data on MS SQL from ORACLE.
Thank you
@Asteroid
January 28, 2009 at 2:22 am
an SSIS package can be created to query the oracle database and insert the results into a sql server database. this package can be ran as a job during the night. if you arent familiar with SSIS then maybe a stored procedure using a linked server to the oracle database could be used.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply