Tell me more ×
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. It's 100% free, no registration required.
up vote 2 down vote favorite

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

share|improve this question
2  
Could you please add more detail about what you're trying to accomplish with the replication setup? – Jon Seigel May 6 at 16:08
1  
I see much pgODBC and OPENROWSET in your future. – swasheck May 6 at 18:16
@swasheck You sound a bit like (an) ORACLE... – Nate May 6 at 18:50

1 Answer

up vote 3 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 at 19:10

Your Answer

 
discard

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.