> Hi, actually what I was after was a continuous way to keep a > PostgreSQL db in sync with a changing MSSQL db.
> Once the data is migrated, a method of syncing any updates > in the MSSQL db to the PostgreSQL db is what we require. > I haven't discovered a nice way of doing that yet. I've setup an active sync between an AS400->MSSQL which would work for MSSQL->Postgres. What you need to to is create a trigger on the MSSQL side which writes to a separate table the key fields from the changed table. You then write a program (mine's in Java on the AS400) which checks the tables the trigger wrote, fetches the new data, and updates the target database (postgres). Simply keep the check in a continuous loop (I actually wait a few minutes between checks) and all your data is kept in sync almost realtime. If you do use Java for this, the advantage is you can sync anything with a JDBC driver, although it's probably not the fastest way to do it. ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
