none
Does SQL Server Replication 2017 version work with Oracle 12C ? RRS feed

  • Question

  • Currenty we have publisher as Oracle 12C and Subscriber as SQL Server 2017.

    I wanted to know if SQL Server 2017 Replication supports replication from Oracel 12C Database to SQL Server 2017 database.

    Request you to share details regarding the same , in case if there are supporting facts please do share them as well.

    Thanks in Advance


    Thursday, June 11, 2020 5:39 PM

All replies

  • You are referring to Oracle Publishing. This is no longer supported. You should be able to get this to work still.  You can replicate to Up to Oracle 12c, and from Oracle 12G.
    Thursday, June 11, 2020 6:34 PM
    Moderator
  • Hi Neeraj,

    I researched related documents and found below maybe helpful to you:

    Please also find more details from below:

    Configure an Oracle Publisher

    Best regards,

    Melissa

    -------------------------------------------

    MSDN Community Support

    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Friday, June 12, 2020 1:14 AM
  • Thanks for you response Hilary.

    Can we still set up heterogeneous replication from Oracel 12C Database to SQL Server 2017 database.

    If not could you please let us know which features have been deprecated in SQL server 2017 version due to the replication cannot be performed from Oracel 12C Database to SQL Server 2017 database.

    Friday, June 12, 2020 2:48 AM
  • HI NEERAJ,

    Have you set up heterogeneous replication from Oracel 12C Database to SQL Server 2016 database?

    According to the restrictions I mentioned earlier, Replication from Oracle 10g to SQL Server 2016 and SQL Server 2017 are supported.

    Regarding to the details about which features have been deprecated in SQL server 2017 version, please check below link whether it is helpful to you.

    Design Considerations and Limitations for Oracle Publishers

    As mentioned in the offical document, heterogeneous replication to non-SQL Server subscribers is deprecated. Oracle Publishing is deprecated. To move data, create solutions using change data capture and SSIS.

    Best regards,

    Melissa

    -------------------------------------------

    MSDN Community Support

    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Friday, June 12, 2020 7:14 AM