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 4020A9FB2B7
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon, 10 Jul 2006 12:49:35 -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 92917-05 for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon, 10 Jul 2006 12:49:30 -0300 (ADT)
X-Greylist: delayed 00:21:30.305441 by SQLgrey-
Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159])
	by postgresql.org (Postfix) with ESMTP id A2B8E9FB28F
	for <pgsql-sql@postgresql.org>; Mon, 10 Jul 2006 12:49:30 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3
Received: from stockwelldesigngroup.com (mail.stockwelldesigngroup.com
	[66.97.4.21])
	by svr4.postgresql.org (Postfix) with ESMTP id 43BC65AF02D
	for <pgsql-sql@postgresql.org>; Mon, 10 Jul 2006 15:27:59 +0000 (GMT)
Received: from WorldClient by stockwelldesigngroup.com (MDaemon PRO v9.0.1)
	with ESMTP id md50000036808.msg
	for <pgsql-sql@postgresql.org>; Mon, 10 Jul 2006 11:27:56 -0400
Received: from [65.41.91.88] by stockwelldesigngroup.com via WorldClient with
	HTTP; Mon, 10 Jul 2006 11:27:52 -0400
Date: Mon, 10 Jul 2006 11:27:52 -0400
From: "Kevin Bednar" <kevin@stockwelldesigngroup.com>
To: pgsql-sql@postgresql.org
Subject: MS-SQL<->Postgres sync
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="_0710-1127-52-PART-BREAK"
Message-ID: <WorldClient-F200607101127.AA27520002@stockwelldesigngroup.com>
X-Mailer: WorldClient 9.0.1
X-Authenticated-Sender: kevin@stockwelldesigngroup.com
X-Spam-Processed: stockwelldesigngroup.com, Mon, 10 Jul 2006 11:27:56 -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 11:27:57 -0400
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200607/145
X-Sequence-Number: 25719

--_0710-1127-52-PART-BREAK
Content-Type: text/plain; charset=us-ascii

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

--_0710-1127-52-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><FONT 
style="FONT-SIZE: 8pt; FONT-FAMILY: "> <DIV>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&nbsp;an ecommerce system 
for a web site. Any and&nbsp;all help is appreciated since I can't find much 
of anything on syncing these 2 database systems!<BR>&nbsp;</DIV></FONT> <DIV>
<BR>Kevin Bednar<BR>Systems Support<BR>Stockwell Design Group<BR><A 
href="http://www.stockwelldesigngroup.com">
http://www.stockwelldesigngroup.com</A></DIV> <DIV><A 
href="mailto:kevin@stockwelldesigngroup.com">
kevin@stockwelldesigngroup.com</A><BR></DIV></BODY>
</HTML>

--_0710-1127-52-PART-BREAK--