On Mon, Jul 10, 2006 at 01:30:51PM -0500, Scott Marlowe wrote:
> > (which means you have to deal with failures in one database and not
> > another). Is the idea that this is multi-master?
>
> I wonder if it would be possible to write a set of triggers for MSSQL
> that would allow you to run slony
[EMAIL PROTECTED] (Scott Marlowe) writes:
> On Mon, 2006-07-10 at 11:25, Andrew Sullivan wrote:
>> On Mon, Jul 10, 2006 at 11:27:52AM -0400, Kevin Bednar wrote:
>> > Looking to keep 2 databases in sync, at least semi-realtime if possible,
>> > although running a batch update every x mins wouldn't
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Scott Marlowe
> Sent: 10 July 2006 20:03
> To: Kevin Bednar
> Cc: Forums @ Existanze; pgsql-sql@postgresql.org
> Subject: Re: [SQL] MS-SQL<->Postgres sync
>
> I thi
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:
> >
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.
I think the to-be-released stuff is supposed to have Windows support.
They were supposed to release Real Soon Now some time ago, so I guess
they
On Mon, 2006-07-10 at 11:25, Andrew Sullivan wrote:
> On Mon, Jul 10, 2006 at 11:27:52AM -0400, Kevin Bednar wrote:
> > 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
ostgresql.orgDate: Mon,
10 Jul 2006 13:31:35 -0500Subject: 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
[mailto:[EMAIL PROTECTED] 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-re
> On 7/10/06, Kevin Bednar <[EMAIL PROTECTED]> wrote:
> >
> > Thanks Aron. What I'm actually trying to do is this:
> >
> > Postgress in physical store, being used by POS system as the back end.
> > MS-SQL being used on web server by ecommerce system.
> >
> > Table structures are different of cours
Yeah, I was kind of thinking that myself. I do have control over both DB's,
and postgres does have an ODBC connector available as well. Perhaps using a
trigger to watch a temp table on each site and having it replicate to the
opposite side and then remove the record from the temp table would
Please reply to all when replying on the list...On 7/10/06, Kevin Bednar <[EMAIL PROTECTED]
> wrote:
Thanks Aron. What I'm actually trying to do is this:
Postgress in physical store, being used by POS system as the back
end. MS-SQL being used on web server by ecommerce system.
Ta
On 7/10/06, Kevin Bednar <[EMAIL PROTECTED]> wrote:
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
On Mon, Jul 10, 2006 at 11:27:52AM -0400, Kevin Bednar wrote:
> 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
We are looking for the exact thing but with two PostgreSQL databases
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Kevin
BednarSent: 10 July 2006 18:28To:
pgsql-sql@postgresql.orgSubject: [SQL] MS-SQL<->Postgres
sync
Looking to keep 2 databa
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
15 matches
Mail list logo
