Re: Migrating from a DB2/400 to Postgres. - Mailing list pgsql-general

It may be possible to dump each table to a file on the AS/400 and FTP it to
a PC
I am not certain how this could be done but it should be possible.

If the database is not too big I would be tempted to use an ODBC link to
extract the data
directly into postgres from a VB/Java program that has ODBC connection to
postgres and the 400

Don't forget the useful SYS tables on the 400 (SYSCOLUMNS,SYSTABLES,etc)
that define the database,
these can be very useful

As for how postgres compares with db2/400, postgres is 1000 times more
advanced. DB2/400 doesn't have
full SQL implementation, its basic but can run quickly

MC.






Adam Huuva <sventon@easter-eggs.com> on 28/03/2001 10:56:30

To:   pgsql-general@postgresql.org
cc:    (bcc: Martin Chantler/CIMG/CVG)
Subject:  [GENERAL] Migrating from a DB2/400 to Postgres.


Hello,

I have no experience of AS400 but I might be finding myself migrating a
database from db2/400 to postgres/linux shortly. I suppose it is a
question of making a dump on the db2 and then importing it to postgres.
(The fact that I get more search hits on db2 *core* dumps than data
dumps is not so incouraging...)

Does anybody know what the incompatibilities between these two
file-formats might be, i.e dump format of db2 and import/populate format
of postgres?

Is there some general file format incompatibilities between as400 and
linux/unix???

Might it be wiser to do an intermediary step to a linux db2?

On another note, anybody know how postgres competes with db2?

Questions, questions.. now ideas and answers, yes?

Cheers,
--
Adam Huuva / Easter-eggs                 Spécialiste GNU/Linux
44-46 rue de l'Ouest  -  75014 Paris  -  France -  Métro Gaité
Phone: +33 (0) 1 43 35 00 37    -   Fax: +33 (0) 1 43 35 00 76
mailto:sventon@easter-eggs.com  -   http://www.easter-eggs.com

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html




--

NOTICE:  The information contained in this electronic mail transmission is
intended by Convergys Corporation for the use of the named individual or
entity to which it is directed and may contain information that is
privileged or otherwise confidential.  If you have received this electronic
mail transmission in error, please delete it from your system without
copying or forwarding it, and notify the sender of the error by reply email
or by telephone (collect), so that the sender's address records can be
corrected.