Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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

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

share|improve this answer
So answer is no. – IvanP May 6 '13 at 19:10

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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