Re: Open source replication

From: Rich J <>
Date: Fri, 10 May 2019 12:33:10 -0500
Message-ID: <>

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...


Received on Fri May 10 2019 - 19:33:10 CEST

Original text of this message