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
Question
how to synchronize 2 databases (IFX -- SQL) with FME
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+5- 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...