Smart Sync

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:

 

Leave a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.