6

Is it possible ? Sql Server as publisher(master) and PostgreSql as slave(subscriber) ? Any type of replication really.

4
  • 2
    Could you please add more detail about what you're trying to accomplish with the replication setup?
    – Jon Seigel
    Commented May 6, 2013 at 16:08
  • 1
    I see much pgODBC and OPENROWSET in your future.
    – swasheck
    Commented May 6, 2013 at 18:16
  • @swasheck You sound a bit like (an) ORACLE...
    – Nate
    Commented May 6, 2013 at 18:50
  • any ideas if you can do it the other way round, PostGres (Master) to SQL server express (slave) Commented Nov 12, 2015 at 14:54

1 Answer 1

6

Only ORACLE and IBM-DB2 are officially supported as subscribers. Refer here and here for more details.

Also, from sql server 2012, this is being depreciated as well.

Heterogeneous replication to non-SQL Server subscribers is deprecated. Oracle Publishing is deprecated. To move data, create solutions using change data capture and SSIS. Caution : This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

Below is a blog post that I found that might be useful to you: Replicating from MS SQL Server to PostgreSQL

1
  • So answer is no.
    – IvanP
    Commented May 6, 2013 at 19:10

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.