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
+4- Contributor
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
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.