4 ms·
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
by radiowave 13y ago
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/ http://www.sql-workbench.net/