ETL is the tool of choice for big data transportation and transformation.
by udid
tags:
border:
Pentaho Data Integration (Kettle) has two cool steps that can "diff" and "patch" database tables.
They can be usefull when you need to sync two tables across databases and would not want to "drop-and-load" the entire table each time or when you have a large update and you want to take updates and inserts from batch files.