Re: Oracle to Informix migration

I haven't much experience with oracle but maybe you use the data transformation services of Sql Server... Yes I know it may sounds bizarre but DTS just does that connect to a source db to transfer information to a target db. I haven't used this tool to transfer an entire system but if you have odbc driver to connect to oracle and informix then DTS try to guess the types but it is not perfect so you have to review what the whole process is doing. If the source db is big then the previous approach might not be well suited. J. Joerg Volz wrote: > 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 > > > sending to informix-list