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 C65269FB328 for ; Mon, 10 Jul 2006 13:06:58 -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 94875-10 for ; Mon, 10 Jul 2006 13:06:50 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 3312B9FB2E2 for ; Mon, 10 Jul 2006 13:06:50 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from deliver.hol.gr (unknown [62.38.3.139]) by svr4.postgresql.org (Postfix) with ESMTP id 38C285AF02E for ; Mon, 10 Jul 2006 16:06:49 +0000 (GMT) Received: from auth-smtp.hol.gr (takeit01.mail.dc.hol.net [192.168.20.71]) by deliver.hol.gr (8.12.11/8.11.6) with ESMTP id k6AG61rB028313 (using TLSv1/SSLv3 with cipher DHE-RSA-AES256-SHA (256 bits) verified OK) for ; Mon, 10 Jul 2006 19:06:01 +0300 Received: from pimp (static223128.dsl.hol.gr [62.38.223.129]) by auth-smtp.hol.gr (8.13.1/8.12.11) with ESMTP id k6AG6gmF032317 for ; Mon, 10 Jul 2006 19:06:42 +0300 Message-Id: <200607101606.k6AG6gmF032317@auth-smtp.hol.gr> From: "Forums @ Existanze" To: Subject: Re: MS-SQL<->Postgres sync Date: Mon, 10 Jul 2006 19:06:54 +0300 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0089_01C6A454.021E8300" X-Mailer: Microsoft Office Outlook, Build 11.0.5510 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869 Thread-Index: AcakOfD/mQnmMBLaTj6dQYvaxhiYAgAANmQA In-Reply-To: X-Virus-Scanned: ClamAV 0.87/1590/Mon Jul 10 08:34:09 2006 on takeit01.mail.dc.hol.net X-Virus-Status: Clean X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/146 X-Sequence-Number: 25720 This is a multi-part message in MIME format. ------=_NextPart_000_0089_01C6A454.021E8300 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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 ------=_NextPart_000_0089_01C6A454.021E8300 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable
 
We are looking for the exact thing=  but with two PostgreSQL databases=

 
From: = pgsql-sql-owner@postgresql.org=20 [mailto:pgsql-sql-owner@postgresql.org] On Behalf Of Kevin=20 Bednar
Sent: 10 July 2006 18:28
To:=20 pgsql-sql@postgresql.org
Subject: [SQL] = MS-SQL<->Postgres=20 sync

Looking to keep 2 databases in sync, at least semi-realtime if = possible,=20 although running a batch update every x mins wouldn't be out of the = question.=20 One db is postgres and the other is ms-sql. It's to keep inventory in = sync=20 from 2 seperate locations, one being a brick and mortar store and the=20 other an ecommerce system for a web site. Any and all help = is=20 appreciated since I can't find much of anything on syncing these 2 = database=20 systems!
 

Kevin Bednar
Systems Support
Stockwell Design = Group
http://www.stockwelldesigngr= oup.com
kevin@stockwelldesigngroup= .com
------=_NextPart_000_0089_01C6A454.021E8300--