Re: Oracle to Informix migration

"Joerg Volz" <joerg@kmjv.de.nixwerbung> wrote in message news:4252f61a$1@news.punkt.de... > Hy, > > I am using Informix ON-Line since Release 4.1. > Now I need to transfer several tables from an old Oracle 8.0.x to Informix. > As I have no idea of oracle and the manuals (as far as I could find them at > the clients place) are more or less useless without experience. There is > also the factor time. > > I am now looking or a tool beeing able to connect to Informix On-Line 10 as > target system and Oracle 8 as Source System, doing the following: > > -connect to both worlds > -EX-/Import of databases and tables from Oracle to Informix > -automatic conversion of variable Types > -Export/Import to ASCII files > > Does anyone have a (product) hint for me where to look? Google delivers to > much without real information except high prices ... > > Thanks in advance. > > > Joerg > Don't know how much the tools cost, but <heresy> SQL Server and DTS is bloody effective and flexible for that king of thing. A SQL Server licence may cost less than a specific migration tool, gives you another valuable skillset and if you want it a base for your datawarehouse with built in OLAP for nothing - which works with the likes of business Objects, and Excel for your beancounters if you are using win* in the desktop </heresy> Altough, if you're an *IX site, obviously you's need to factor in te cost of an appropriate server which makes thecosts rise rater a lot.