To synchronize data from Oracle in real time to MS SQL Server, you need to read and write data directly to SQL Server in Oracle, and you can install the Oracle database for SQL Servers component on the Oracle about how to install this component, the Web can not find the details, special to my installation process recorded to share to the needs of netizens:
1.Oracle Enterprise Edition comes with Gateway for ODBC, but the for SQL Server version is not installed and needs to be downloaded to the official website. First open the Oracle website and go to Oracle 11g Download homepage (according to your own version):
Http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html
Select the 32-bit or 64-bit version based on the server's model, and click the " See all" link after the version download link:
2. then find Oracle Database gateways-g Release 2 (11.2.0.1.0) for Microsoft Windows
and download. This file has 538M.
Oracle Direct Read and write MS SQL Server database (i) How to download Oracle DB Gateway for SQL Server