Java library to partially export a database while respecting referential integrity constraints

My production database is several GB's uncompressed and it's getting to be a pain to download and run locally when trying to reproduce a bug or test a feature with real data.

I would like to be able to select the specific records that interest me, then have the library figure out what other records are necessary to produce a dataset开发者_如何学Go that respects the databases integrity constraints and finally print it out as a list of insert statements or dump that I can restore.

For example:

• given Author, Blog and Comment tables
• when I select comments posted after a certain date
• I should get inserts for the Blog records the comments have foreign keys to and the Author records those Blogs have foreign keys to.

this looks like what you look for Jailer

It exports consistent, referentially intact row-sets from relational databases.