pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Scott Marlowe <smarlowe@g2switchworks.com>
To: Forums @ Existanze <forums@existanze.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: MS-SQL<->Postgres sync
Date: Mon, 10 Jul 2006 13:31:35 -0500
Message-ID: <1152556295.6540.16.camel@state.g2switchworks.com> (raw)
In-Reply-To: <200607101606.k6AG6gmF032317@auth-smtp.hol.gr>
References: <200607101606.k6AG6gmF032317@auth-smtp.hol.gr>

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
>         



view thread (15+ messages)  latest in thread

Message-ID: <1152556295.6540.16.camel@state.g2switchworks.com>
Permalink:  ../1152556295.6540.16.camel@state.g2switchworks.com/
Also on:    postgresql.org/message-id/1152556295.6540.16.camel@state.g2switchworks.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: smarlowe@g2switchworks.com, forums@existanze.com
  Subject: Re: MS-SQL<->Postgres sync
  In-Reply-To: <1152556295.6540.16.camel@state.g2switchworks.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox