none
Heterogeneous Replication to Oracle subscriber

    Question

  • Hi,

    I currently have "SQL Server 2008 R2" as Publisher/Distributor and I want to setup replication to Oracle database 12c (subscriber).

    After adding Oracle database 12c as subscriber to a publication, sp_helpdatatypemap shows oracle destination versions only till 11g. Now, I am looking for help on... How to adding data mapping between "SQL Server 2008 R2" and Oracle database 12c.

    Thank you.


    Tuesday, May 21, 2019 8:10 AM

All replies

  • Hi,

    The sp_helpdatatypemap returns information on the defined data type mappings between Microsoft SQL Server and non- SQL Server database management systems (DBMS). If it shows oracle destination versions only till 11g, then I'm afraid you can only use data type mappings in oracle 11g.

    Best Regards,
    Puzzle
    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

    Wednesday, May 22, 2019 1:52 AM