From: Scott Marlowe <smarlowe@g2switchworks.com>
To: Andrew Sullivan <ajs@crankycanuck.ca>
Cc: pgsql-sql@postgresql.org
Subject: Re: MS-SQL<->Postgres sync
Date: Mon, 10 Jul 2006 13:30:51 -0500
Message-ID: <1152556251.6540.14.camel@state.g2switchworks.com> (raw)
In-Reply-To: <20060710162520.GA4590@phlogiston.dyndns.org>
References: <WorldClient-F200607101127.AA27520002@stockwelldesigngroup.com>
<20060710162520.GA4590@phlogiston.dyndns.org>
On Mon, 2006-07-10 at 11:25, Andrew Sullivan wrote:
> On Mon, Jul 10, 2006 at 11:27:52AM -0400, Kevin Bednar wrote:
> > Looking to keep 2 databases in sync, at least semi-realtime if possible,
> > although running a batch update every x mins wouldn't be out of the
> > question. One db is postgres and the other is ms-sql. It's to keep inventory
> > in sync from 2 seperate locations, one being a brick and mortar store and
> > the other an ecommerce system for a web site. Any and all help is
> > appreciated since I can't find much of anything on syncing these 2 database
> > systems!
>
> I don't think there's actually any product that does this right now,
> unless you're willing to use some sort of statement replica system
> (which means you have to deal with failures in one database and not
> another). Is the idea that this is multi-master?
I wonder if it would be possible to write a set of triggers for MSSQL
that would allow you to run slony daemons that connected to it and a
postgresql server and did replication. Just mad scientisting for a
second.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: smarlowe@g2switchworks.com, ajs@crankycanuck.ca
Subject: Re: MS-SQL<->Postgres sync
In-Reply-To: <1152556251.6540.14.camel@state.g2switchworks.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox