Replicating data from MS SQL server 2012 to PostgreSQL

  • Hello,

    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?

  • nic2885 - Monday, September 25, 2017 3:05 PM

    Hello,

    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?

    It looks like you may have found that it isn't supported. Refer to the article here:
    Non-SQL Server SubscribersNon-SQL Server Subscribers

    In that article, they recommend SSIS or CDC. There are third party products you could look into. I haven't used any of them so don't know much about them. I did just find an open source database replication software program. It might be worth a try:
    SymmetricDS

    Sue

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply