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 B56D89FB326
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon, 10 Jul 2006 15:59:59 -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 55672-04 for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon, 10 Jul 2006 15:59:54 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from stockwelldesigngroup.com (mail.stockwelldesigngroup.com
	[66.97.4.21]) by postgresql.org (Postfix) with ESMTP id 2C9379FB2F0
	for <pgsql-sql@postgresql.org>; Mon, 10 Jul 2006 15:59:54 -0300 (ADT)
Received: from WorldClient by stockwelldesigngroup.com (MDaemon PRO v9.0.1)
	with ESMTP id md50000036919.msg
	for <pgsql-sql@postgresql.org>; Mon, 10 Jul 2006 14:59:52 -0400
Received: from [65.41.91.88] by stockwelldesigngroup.com via WorldClient with
	HTTP; Mon, 10 Jul 2006 14:59:50 -0400
Date: Mon, 10 Jul 2006 14:59:50 -0400
From: "Kevin Bednar" <kevin@stockwelldesigngroup.com>
To: "Scott Marlowe" <smarlowe@g2switchworks.com>, "Forums @ Existanze"
	<forums@existanze.com>, pgsql-sql@postgresql.org
Subject: Re: MS-SQL<->Postgres sync
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="_0710-1459-50-PART-BREAK"
Message-ID: <WorldClient-F200607101459.AA59500013@stockwelldesigngroup.com>
X-Mailer: WorldClient 9.0.1
In-Reply-To: <1152556295.6540.16.camel@state.g2switchworks.com>
References: <200607101606.k6AG6gmF032317@auth-smtp.hol.gr>
	<1152556295.6540.16.camel@state.g2switchworks.com>
X-Authenticated-Sender: kevin@stockwelldesigngroup.com
X-Spam-Processed: stockwelldesigngroup.com, Mon, 10 Jul 2006 14:59:52 -0400
	(not processed: message from valid local sender)
X-Return-Path: kevin@stockwelldesigngroup.com
X-MDaemon-Deliver-To: pgsql-sql@postgresql.org
X-MDAV-Processed: stockwelldesigngroup.com, Mon, 10 Jul 2006 14:59:53 -0400
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200607/155
X-Sequence-Number: 25729

--_0710-1459-50-PART-BREAK
Content-Type: text/plain; charset=us-ascii

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 <smarlowe@g2switchworks.com>
To: "Forums @ Existanze" <forums@existanze.com>
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

--_0710-1459-50-PART-BREAK
Content-Type: text/html; charset=us-ascii

<HTML>
<HEAD> <META http-equiv=Content-Type content="text/html; charset=us-ascii"> 
<STYLE title="table borders">.htmtableborders, .htmtableborders td, 
.htmtableborders th {border : 1px dashed lightgrey ! important;}  </STYLE>  
<STYLE type=text/css>html, body { border: 0px; }  span.macro, span.macro ul, 
span.macro div, span.macro p {background : #CCCCCC;} </STYLE>  <STYLE 
type=text/css> p{margin-bottom: 0.15em;margin-top: 
0.15em;}body{font-family:;font-size:8pt;}; </STYLE> </HEAD> <BODY> <DIV>Took 
a quick glance but were running windows on both sides and it didnt look like 
that would work. Didnt look real hard though.</DIV> <DIV>&nbsp;</DIV> <DIV>
Kevin</DIV> <DIV>&nbsp;</DIV> <DIV><BR>&nbsp;</DIV> <BLOCKQUOTE 
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: 
#000000 2px solid; MARGIN-RIGHT: 0px">-----Original Message-----<BR>From: 
Scott Marlowe &lt;smarlowe@g2switchworks.com&gt;<BR>To: "Forums @ Existanze" 
&lt;forums@existanze.com&gt;<BR>Cc: pgsql-sql@postgresql.org<BR>Date: Mon, 
10 Jul 2006 13:31:35 -0500<BR>Subject: Re: [SQL] MS-SQL&lt;-&gt;Postgres 
sync<BR><BR> <DIV style="FONT-FAMILY: monospace, courier new, courier">Look 
at slony.<BR><BR>On Mon, 2006-07-10 at 11:06, Forums @ Existanze wrote:<BR>
&gt; &nbsp;<BR>&gt; We are looking for the exact thing but with two 
PostgreSQL databases<BR>&gt; &nbsp;<BR>&gt; &nbsp; &nbsp; &nbsp; &nbsp; <BR>
&gt; &nbsp; &nbsp; &nbsp; &nbsp; 
______________________________________________________________<BR>&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; From: pgsql-sql-owner@postgresql.org<BR>&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; [mailto:pgsql-sql-owner@postgresql.org] On 
Behalf Of Kevin<BR>&gt; &nbsp; &nbsp; &nbsp; &nbsp; Bednar<BR>&gt; &nbsp; 
&nbsp; &nbsp; &nbsp; Sent: 10 July 2006 18:28<BR>&gt; &nbsp; &nbsp; &nbsp; 
&nbsp; To: pgsql-sql@postgresql.org<BR>&gt; &nbsp; &nbsp; &nbsp; &nbsp; 
Subject: [SQL] MS-SQL&lt;-&gt;Postgres sync<BR>&gt; &nbsp; &nbsp; &nbsp; 
&nbsp; <BR>&gt; &nbsp; &nbsp; &nbsp; &nbsp; <BR>&gt; &nbsp; &nbsp; &nbsp; 
&nbsp; Looking to keep 2 databases in sync, at least semi-realtime if<BR>
&gt; &nbsp; &nbsp; &nbsp; &nbsp; possible, although running a batch update 
every x mins<BR>&gt; &nbsp; &nbsp; &nbsp; &nbsp; wouldn't be out of the 
question. One db is postgres and the<BR>&gt; &nbsp; &nbsp; &nbsp; &nbsp; 
other is ms-sql. It's to keep inventory in sync from 2<BR>&gt; &nbsp; &nbsp; 
&nbsp; &nbsp; seperate locations, one being a brick and mortar store and 
the<BR>&gt; &nbsp; &nbsp; &nbsp; &nbsp; other an ecommerce system for a web 
site. Any and all help is<BR>&gt; &nbsp; &nbsp; &nbsp; &nbsp; appreciated 
since I can't find much of anything on syncing<BR>&gt; &nbsp; &nbsp; &nbsp; 
&nbsp; these 2 database systems!<BR>&gt; &nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp;<BR>&gt; &nbsp; &nbsp; &nbsp; &nbsp; Kevin Bednar<BR>&gt; &nbsp; 
&nbsp; &nbsp; &nbsp; Systems Support<BR>&gt; &nbsp; &nbsp; &nbsp; &nbsp; 
Stockwell Design Group<BR>&gt; &nbsp; &nbsp; &nbsp; &nbsp; <A 
href="http://www.stockwelldesigngroup.com" target=_blank>
http://www.stockwelldesigngroup.com</A><BR>&gt; &nbsp; &nbsp; &nbsp; &nbsp; 
kevin@stockwelldesigngroup.com<BR>&gt; &nbsp; &nbsp; &nbsp; &nbsp; <BR><BR>
---------------------------(end of broadcast)---------------------------<BR>
TIP 4: Have you searched our list archives?<BR><BR>&nbsp; &nbsp; &nbsp; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<A href="http://archives.postgresql.org" 
target=_blank>http://archives.postgresql.org</A><BR></DIV></BLOCKQUOTE>
</BODY>
</HTML>

--_0710-1459-50-PART-BREAK--