I have an application which stores data to MS SQL server 2012. I want to replicate this data real time to postgreSQL. After some massaging and modifications, I want to real time replicate this data to another MS SQL server 2012 server.
When I tried this using transactional replication, I could see only 2 non-sql server subscriber options (Oracle and IBM DB2) I do not get any other option. I have already added Postgres as ODBC 64 bit System data source. Even if microsoft is planning to deprecate heterogeneous data replication in future, any time being solution would be highly appreciated. Is transactional replication between SQL server and PostgreSQL is possible?