syncing MSSQL and Postgres
syncing MSSQL and Postgres
От:
Raphael Bauduin <raphael@be.easynet.net>
Дата:
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