Re: Oracle to Informix migration
On Fri, 18 Nov 1994, David Harold Lipschitz wrote:
} In article <3aeae9$fts@emory.mathcs.emory.edu>
} mark@dsl.com "Mark Lansley" writes:
}
} >
} > What tools (if any) are available to migrate an Oracle 7 to Informix DSA 6
} > Database. The source database(s) are going to be quite large (6GB +) with
} > a significant number of tables (1000+), so it would be ideal if it could
} > convert from an offline database export directy into Informix (of course
} > I'm probably being ambitious but if you don't ask you never get).
} >
} > And suggestions of sed-awk-perl-grep-gnash-bish-bash-bosh don't strike me
} > as workable with such a large volume of data. :-)
} >
} > Regards, Mark
}
} Why don't you use the standard dbexport and dbimport commands?
Because I'm lazy. But in truth the idea of having to use dbexport and
dbimport to convert 1757 DDL statements and the associated data does worry
me a little bit. Strikes me as something software would be more efficient
at.
} --
} David H Lipschitz email: david@lipdav.demon.co.uk
} Orbital Decisions: decision support services to bulk shipping companies
} The opinions are probably those of my company. I own the company
} If you don't try, you won't know
}
}
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Mark Lansley <mark@dsl.com> | "Whoa!....Maybe I'll just pass
Druid Systems Ltd, UK | on my usual barking frenzy."
+44 932 571212 (Vce) 571552 (Fax) |
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~