Migration to DB2

Posted in 1999

Topics: Migration, Import/Export & Data Conversion

ML — 16 Dec 1999 07:42:06 GMT — source: Informix-list mailing list archive (1991-1998)

Hi, I want to migrate my informix database to DB2. I have an idea how to export the data (with UNLOAD statement) but no idea how to export the structure of tables. Have you got a simply way to create or import the tables in DB2 ? TIA M.L. =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Article poste via Voila News - http://www.news.voila.fr Le : Thu Dec 16 08:42:06 1999 depuis l'IP : 194.51.169.175

↪ replying to ML

QueriX / Mehdi — Thu, 16 Dec 1999 15:44:40 +0000 — source: Informix-list mailing list archive (1991-1998)

ML wrote: > Hi, > > I want to migrate my informix database to DB2. > > I have an idea how to export the data (with UNLOAD statement) but no > idea how to export the structure of tables. > > Have you got a simply way to create or import the tables in DB2 ? > > TIA > > M.L. > > =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- > Article poste via Voila News - http://www.news.voila.fr > Le : Thu Dec 16 08:42:06 1999 depuis l'IP : 194.51.169.175 use dbschema to create an sql file use this file (you may have to edit a little, I am not familiar with the SQL standard of DB2) to create the schema of the tables on DB2. -- Compliments of QueriX -------------------------------------------------------------------------------------------------- QueriX 4GL Compilers are Informix 4GL Compatible, and Connection to other RDBMS such as Oracle. Hydra 4GL Compiler Compile once, run everywhere Phoenix Windows GUI. Chimera Java GUI The only GUI you will ever need... Arachne Web Technology For more details visit: http://www.querix.com/ ---------------------------------------------------------------------------------------------------