January 28, 2009 at 2:24 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 7:49 am
Upgrade to SQL 2005 or 2008 😉
You can't really create a pull subscription as such from Oracle to SQL Server in this version. You have a couple of options, you could use triggers to put the data into a table and then read from that table.
Alternatively you could replicate the data out of Oracle and into SQL using an ODBC driver using Heterogeneous replication on Oracle.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply