syncing MSSQL and Postgres

From: Raphael Bauduin <raphael(at)be(dot)easynet(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: syncing MSSQL and Postgres
Date: 2002-02-27 11:03:49
Message-ID: 20020227110349.GA24557@raphael
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I'd like to replicate a database in a MS-SQL server to a Postgresql server. I found
two documents on techdocs.postgresql.org, but if you have experience with this, your
advice is welcome :-)

But my question is about the next step: is it possible, once the db is duplicated in pgsql, to
keep the data synchronized? Data will be inserted in the MS-SQL database only, but I'd like
to update the postgresql data each time the MS-SQL data is modified (rows inserted, deleted, updated).

Thanks in advance.

Raph

Browse pgsql-admin by date

  From Date Subject
Next Message Richard Ray 2002-02-27 14:00:22 List help
Previous Message Nikolay Mihaylov 2002-02-27 08:00:39 FW: Pg_dump very large database