Archiving Database Tables using Java
- by HonorGod
My application demands archiving database tables between sybase and db2 and vice-a-versa and within(db2 to db2 and sybase to sybase) using java.
I am trying to understand the best strategies around in terms performance, implementation, ease of use and scalability.
Here is my current process -
source and destination tables with the acceptable parameters (from java) are defined within xml.
the application reads the source and destination configurations and execute them sequentially.
destination is sometime optional when source is just deleting data from a specific table or when the source is just calling a stored procedure.
dataset between source and destination is extremely large (in millions)
From top of my head, it looks like I can define dependencies between multiple source and destination combination and have them execute in parallel in multiple treads. But will this improve any performance(i hope it will)?
Are there any open-source frameworks for data archiving using java? Any other thoughts on the implements side will be really helpful.
Thanks