The problem is we need to copy data routinely ie set up automation to copy data from a sql server database to an oracle.
What would you recommend?
I looked into doing it with an SSIS package but we have server 2012 and needs to interact with the oracle client to work. Is there a way of firing the data strait into the oracle database without client software etc necessary on oracle server? Thanks