X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 99EA29FB26C for ; Mon, 10 Jul 2006 22:04:16 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 31304-01 for ; Mon, 10 Jul 2006 22:04:06 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from floppy.pyrenet.fr (floppy.pyrenet.fr [194.116.145.2]) by postgresql.org (Postfix) with ESMTP id 9AB6D9FB281 for ; Mon, 10 Jul 2006 22:04:06 -0300 (ADT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 380C530B4B; Tue, 11 Jul 2006 03:04:05 +0200 (MET DST) From: Chris Browne X-Newsgroups: pgsql.sql Subject: Re: MS-SQL<->Postgres sync Date: Mon, 10 Jul 2006 20:12:51 -0400 Organization: cbbrowne Computing Inc Lines: 32 Message-ID: <607j2lrocc.fsf@dba2.int.libertyrms.com> References: <20060710162520.GA4590@phlogiston.dyndns.org> <1152556251.6540.14.camel@state.g2switchworks.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org User-Agent: Gnus/5.1007 (Gnus v5.10.7) XEmacs/21.4.19 (linux) Cancel-Lock: sha1:VPZvdID9hf0nWhRAEyX3/wiuZ5Y= To: pgsql-sql@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/166 X-Sequence-Number: 25740 smarlowe@g2switchworks.com (Scott Marlowe) writes: > 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. Someone went through the "mental gyrations" and figured it ought to be able to work for Oracle... It otta be able to work; the only thing is that I would think the only nodes that could be origins would be PostgreSQL nodes, because the way the data extraction scheme works is very much attuned to PostgreSQL's MVCC model... -- output = ("cbbrowne" "@" "cbbrowne.com") http://cbbrowne.com/info/lisp.html "I don't plan to maintain it, just to install it." -- Richard M. Stallman