One-time transfer of data using Java/jdbc, DOM, and XSLT. A generic
data transfer and manipulation tool takes about three days to write from
scratch with this combination and runs as fast as any vendor’s data
loading tool.
I can’t get more specific than this without violating my employment
contract.
I also would do a one-time data transfer. It would be awesome if
Goldmine had something like a export to CSV option; then you could just
import it and transform it.
If you’re stuck hacking the legacy db all by yourself, see if someone
else has written some sort of export tool. Failing that, you have to
write a program to transform the data into some format that would make
sense for your app.