Skip to main content
  • EN

I want to synchronize (INSERT,UPDATE, DELETE) 2 databases, source is Informix and target is SQL), anyone has an example to do it??.

Finally i want the SQL database gets all changes of the Source Database (ifx),

Thanks for your help

I don't know much about these formats of databases, but we work a lot with Smallworld database. So maybe this is applicable to your problem:

By using UpdateDetector transformer (from FME Store) we defined which data was updated, inserted or deleted (writen as fme_db_operation). We based this on attribute Date Modified, so everything that had newer date from revised (new) database went to one of before mentioned outputs (update, insert, delete). After that fme_where field is defined (using AttributeCretor) and writen to final database acording to operation from fme_db_operation.

Hope that helps...

Reply


Community Stats

30,108
Posts
114,277
Replies
37,740
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.