I need to know how can I port data from DB2 UDB 9.7 database (linux environment )to Informix 12.10 DB on Window based platform. What are the prerequisites before porting? Any suggestion is welcomed. I googled but didn't get much on that except the other way around.
What sort of "port" do you need?
- Do you need regular updates or it's a one case situation?
- How many tables?
All the solutions I can think about should work both ways:
- Replication products like CDC (Change Data Capture)
- Some application that fetches data from DB2 and inserts on Informix (any JDBC application connecting to both)
- Informix Gateway
- Probably DB2 CONNECT assuming you confire Informix for DRDA