My production database is several GB's uncompressed and it is dealing with be considered a discomfort to download and run in your area when attempting to breed a bug or test an element with real data.

I must have the ability to choose the particular records that interest me, then possess the library evaluate which other records are essential to make a dataset that respects the databases integrity constraints and lastly print it as a listing of place claims or dump will be able to restore.

For instance:

  • given Author, Blog and Comment tables
  • after i choose comments published following a certain date
  • I ought to get card inserts for that Blog records your comments ought to have foreign secrets to and also the Author records individuals Blogs have foreign secrets to.

this appears like that which you search for Jailer

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