[Treebase-devel] db2->pg data transfer

[Rutger V. <rut...@gm...>]

Hi,

Mark-Jason and I just met to discuss how to transfer data from DB2
(sdsc) to pg (nescent). We considered the following options:

1. DB2 uses an export file format called IXF, which pg doesn't
support. There are different versions of IXF, googling for tools that
might convert/import IXF only turns up things that look dodgy. An
unattractive possibility is that we write our own IXF parser.

2. Perhaps Hibernate has a facility to dump a database's contents to a
format that can be imported (say, select statements). You'd think that
Hibernate would have this, but we haven't found it.

3. Write our own exporter. Mark-Jason did some preliminary work on a
java-based "dump table to delimited file" exporter. Since we can run
DBD::DB2 on gigahertz.sdsc.edu we might do something along those lines
in perl. We note Hilmar's remarks about the dangers with this: need to
keep track of character encodings and escape sequences.

I am now investigating option 2. We may have to open door 3, but we'd
like to hear your suggestions/remarks.

Rutger

-- 
Dr. Rutger A. Vos
Department of zoology
University of British Columbia
http://www.nexml.org
http://rutgervos.blogspot.com