Re:Ask HN: What are the best tools for DB ingestion?
by radiowave on Saturday December 14, 2013 @08:37AM
(#6905640)
I use SQL Workbench for bulk loading data from a legacy database into postgres, inserting or updating about 600,000 rows nightly. (It'll work with any database via JDBC.) A good starting point is to run some imports interactively using the "data pumper" section of the GUI, and then there's a button which shows you the equivalent script. Support is via a google group, and is excellent.
http://www.sql-workbench.net/