Re: [Treebase-devel] TreeBASE migration project

[Mark D. <mjd...@ge...>]

Hilmar Lapp wrote:
>> I understand there is probably some way to dump the TB2-format data as
>> it currently exists at SDSC, transfer the dump files to NESCent, and
>> bulk-load them into the database on the NESCent side.
> 
> In theory yes, but in practice each RDBMS has its own dump format.  
> Ideally we can get DB2 to dump the data as SQL standard-compliant  
> INSERT statements, but I don't know DB2 enough yet to know whether it  
> does that, and aside from that there's more than the data itself, such  
> as the sequence(s), grants, etc that may not dump in a format that's  
> readily ingestible by Pg.

It appears that DB2 will dump the data in only one useful format, called 
IXF.  Do you know if Pg can import that?  if not we may have to do 
something.

Also, although most of the database is pretty small, there is one table 
with around 3e8 rows, and it may not be practical to export this to a 
file or to transport the file.