Re: Open source replication

On 2019/05/10 11:52, Sweetser, Joe wrote:

> All this GoldenGate talk got me thinking. I have a need to replicate some tables from Oracle to MSSQL. Pretty vanilla. Source datatypes are varchar2, numeric, and date. It's NOT mission critical, but it will be sorta visible. :)

If you can pull data from Oracle instead of pushing to MSSQL, a Linked Server in MSSQL is all you need. And likely the Agent, which will run the Job you create. And an Oracle client install on the MSSQL server, but that's it. :)

Use your favorite search engine with "mssql openquery oracle".

Just a thought...

Rich

--
http://www.freelists.org/webpage/oracle-l