Database Subsetting and Relational Data Browsing Tool. Navigate bidirectionally through the database by following foreign-key-based or user-defined relationships. Exports consistent, referentially intact row-sets from relational databases. Removes data w/o violating integrity. Generates topologically sorted SQL-DML, hierarchically structured XML. and DbUnit datasets.
Features
- Exports consistent and referentially intact row-sets from your productive database and imports the data into your development and test environment.
- Improves database performance by removing and archiving obsolete data without violating integrity.
- Generates topologically sorted SQL-DML, hierarchically structured XML and DbUnit datasets.
- Data Browsing. Navigate bidirectionally through the database by following foreign-key-based or user-defined relationships.
- SQL Console with code completion, syntax highlighting and database metadata visualization.
- Documentation: http://jailer.sourceforge.net/
- API provides programmatic access to export/import functionality. http://jailer.sourceforge.net/api.html
- https://github.com/Wisser/Jailer
Project Samples
License
Apache License V2.0Follow Jailer
Other Useful Business Software
Rate This Project
Login To Rate This ProjectUser Reviews
-
Excellent software. I needed something to help me create a subset database and within 15 minutes I had one. Easy to use and understand. Thank you!
-
I love this tool, especially the liquibase export feature. It has allowed me to develop a efficient customer data migration process. I expect I will find other ways to make use of it too. The developer is responsive and very helpful.
-
Brilliant tool, don't know anything like it :-)
-
Very usefull tool. I use it for Test Data Management.
-
Amazingly slick tool that is immensely useful (after some time spent on getting to know it properly)!