Re: Dump Database / Porting Database to Oracle

Hi Sven. Try the following command. dbexport <your database>. Then creating current directry <your database.dbs> .unl is ASCII file .sql is create table script. Regards. -- Tsutomu Ogiwara from Tokyo Japan. ICQ#:168106592 >From: s.anders@digitec.de (Sven Anders) >Reply-To: s.anders@digitec.de (Sven Anders) >To: informix-list@iiug.org >Subject: Dump Database / Porting Database to Oracle >Date: 15 Oct 2003 23:35:11 -0700 > >Hi, >I do not know much about informix. I have no running instance here, >but its my job to transfer data from informix to oracle. > >- Is there a tool to dump a whoole database into an ASCII file? > >- In mysql there is a tool called "mysqldump" which dumps the whole >database and create a file with sql statements (create, insert , >insert ...), so >you can transfer the whole database with mysqldump >file.sql and mysql ><file.sql. Is there such a tool in informix? (I have seen that there >is a >infdump direcorty) > >- Is there a good way or a (cheap) tool to transfer a database from >infomix to oracle? > >Best Regards > >Sven Anders, Digitec GmbH _________________________________________________________________ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail sending to informix-list