Thread: syncing MSSQL and Postgres

syncing MSSQL and Postgres

From
Raphael Bauduin
Date:
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