Share via

Replication From Oracle to SQL and back to Oracle

  • Article

Have you ever tried the Replication from Oracle to SQL using the add Oracle publication feature in SQL Server Replication. following the steps simply you'll get the job done but when you try to put back data into the same oracle database you'll receive this error

"Heterogeneous publisher 'You Database' cannot be defined as a subscriber"

so what's the resolution ? simply do the following steps

1. open the tnsnames.ora

2. copy your tns definition and paste it but change the name of the tns itself so you'll have 2 connections with different tns names

3. use the second one as your subscriber it'll work very smoothly.

does it ?