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 094A49FB286 for ; Mon, 10 Jul 2006 16:02:45 -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 54427-10 for ; Mon, 10 Jul 2006 16:02:36 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from exchange.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by postgresql.org (Postfix) with ESMTP id A12369FB284 for ; Mon, 10 Jul 2006 16:02:36 -0300 (ADT) Received: from 10.10.1.37 ([10.10.1.37]) by exchange.g2switchworks.com ([10.10.1.2]) with Microsoft Exchange Server HTTP-DAV ; Mon, 10 Jul 2006 19:02:35 +0000 Received: from state.g2switchworks.com by mail.g2switchworks.com; 10 Jul 2006 14:02:35 -0500 Subject: Re: MS-SQL<->Postgres sync From: Scott Marlowe To: Kevin Bednar Cc: "Forums @ Existanze" , pgsql-sql@postgresql.org In-Reply-To: References: <200607101606.k6AG6gmF032317@auth-smtp.hol.gr> <1152556295.6540.16.camel@state.g2switchworks.com> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1152558155.6540.18.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Mon, 10 Jul 2006 14:02:35 -0500 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/160 X-Sequence-Number: 25734 I think there's a version with windows support due out soon. Not sure, since I don't run windows... just remember seeing it mentioned. On Mon, 2006-07-10 at 13:59, Kevin Bednar wrote: > Took a quick glance but were running windows on both sides and it > didnt look like that would work. Didnt look real hard though. > > Kevin > > > -----Original Message----- > From: Scott Marlowe > To: "Forums @ Existanze" > Cc: pgsql-sql@postgresql.org > Date: Mon, 10 Jul 2006 13:31:35 -0500 > Subject: Re: [SQL] MS-SQL<->Postgres sync > > Look at slony. > > On Mon, 2006-07-10 at 11:06, Forums @ Existanze wrote: > > > > We are looking for the exact thing but with two PostgreSQL > databases > > > > > > > ______________________________________________________________ > > From: pgsql-sql-owner@postgresql.org > > [mailto:pgsql-sql-owner@postgresql.org] On Behalf Of > Kevin > > Bednar > > Sent: 10 July 2006 18:28 > > To: pgsql-sql@postgresql.org > > Subject: [SQL] MS-SQL<->Postgres sync > > > > > > 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! > > > > Kevin Bednar > > Systems Support > > Stockwell Design Group > > http://www.stockwelldesigngroup.com > > kevin@stockwelldesigngroup.com > > > > ---------------------------(end of > broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org >