4 ms·

Does MS-SQL have anything like PostGres' Bidirectional replication? Also, Postgres is missing multiple result sets, which Sql Server seems to have, right?

dsp1234 11y ago
Does MS-SQL have anything like PostGres' Bidirectional replication? Yes. https://msdn.microsoft.com/en-us/library/ms151196.aspx https://msdn.microsoft.com/en-us/library/ms151196.aspx https://msdn.microsoft.com/en-us/library/ms151855.aspx https://msdn.microsoft.com/en-us/library/ms151855.aspx
- kbenson 11y ago
  One thing to be said about Microsoft and their products is that they probably support what you want to do. It may cost you an arm and a leg, but it's probably supported (as with most high-end enterprise products, I find). It's easy to see how this came about, too. "We have a multi-million dollar sale on our hand, but they really want feature X. Guess we can subsidize the development with that sale."
  - cptskippy 11y ago
    I feel like cost has only really become an issue recently with their drive to get everyone in the cloud or on Azure and even then it's only an issue for small businesses. They offer ridiculous discounts to nonprofits and in education settings it's basically free.
mioelnir 11y ago
Sadly, even the basic synchronous mirroring with automatic failover that MSSQL offers is ahead of anything pgsql can offer at the current time.
tracker1 11y ago
I'm not as familiar with later versions of MS-SQL, but it's replication story is well in the box... Postgres is a bolted on, hard to setup/maintain hodge podge... I really hope the out of the box, via a gui admin and all story for replication on postgres gets to where MS-SQL was in the box in 2005. NOTE: this is not a bash or nag on postgres, I really like it's JSON integration, and plv8 is awesome. That said, even simple replication stories in pgsql have me pulling my hair out, mainly because I don't WANT to know every intricate detail about my dbms, I just want to build applications on top of it, and ms-sql is pretty nice in that regard.
- cptskippy 11y ago
  Admittedly I've never used the replication in Postgres but that surprises me. I don't think I had the opportunity to use replication in MSSQL 2005 but it was pretty awful 2003 and pretty terrific in 2008 so I guess it was fixed somewhere in between.

dsp1234 11y ago

Does MS-SQL have anything like PostGres' Bidirectional replication? Yes. https://msdn.microsoft.com/en-us/library/ms151196.aspx https://msdn.microsoft.com/en-us/library/ms151196.aspx https://msdn.microsoft.com/en-us/library/ms151855.aspx https://msdn.microsoft.com/en-us/library/ms151855.aspx

kbenson 11y ago
One thing to be said about Microsoft and their products is that they probably support what you want to do. It may cost you an arm and a leg, but it's probably supported (as with most high-end enterprise products, I find). It's easy to see how this came about, too. "We have a multi-million dollar sale on our hand, but they really want feature X. Guess we can subsidize the development with that sale."
- cptskippy 11y ago
  I feel like cost has only really become an issue recently with their drive to get everyone in the cloud or on Azure and even then it's only an issue for small businesses. They offer ridiculous discounts to nonprofits and in education settings it's basically free.

mioelnir 11y ago

Sadly, even the basic synchronous mirroring with automatic failover that MSSQL offers is ahead of anything pgsql can offer at the current time.

tracker1 11y ago

I'm not as familiar with later versions of MS-SQL, but it's replication story is well in the box... Postgres is a bolted on, hard to setup/maintain hodge podge... I really hope the out of the box, via a gui admin and all story for replication on postgres gets to where MS-SQL was in the box in 2005. NOTE: this is not a bash or nag on postgres, I really like it's JSON integration, and plv8 is awesome. That said, even simple replication stories in pgsql have me pulling my hair out, mainly because I don't WANT to know every intricate detail about my dbms, I just want to build applications on top of it, and ms-sql is pretty nice in that regard.

cptskippy 11y ago
Admittedly I've never used the replication in Postgres but that surprises me. I don't think I had the opportunity to use replication in MSSQL 2005 but it was pretty awful 2003 and pretty terrific in 2008 so I guess it was fixed somewhere in between.