On 2002, I was forced to build a small java class to “sync” two databases (sorry for Italian):
SmartSync used the Metadata offered by JDBC API to be able to copy data between two tables.
In the last years I evolved it to be able to support a special use case called “dump to SQLite”.
I am a sqlite fan, and sometimes I need to stage data for Data Warehouse study or simple for off-line analysis.
SmartSync was a winner in such scenarios. It is still in beta, full of rouch edges, but it works on JDK 11 and look cool: