What is Jailer?
It is a tool for database subsetting, schema and data browsing. It exports consistent, referentially intact row-sets from relational databases. It removes obsolete data without violating integrity. It is DBMS agnostic (by using JDBC), platform independent, and generates DbUnit datasets, hierarchically structured XML, and topologically sorted SQL-DML.
Jailer is a tool in the Database Tools category of a tech stack.
Jailer is an open source tool with 2.7K GitHub stars and 109 GitHub forks. Here’s a link to Jailer's open source repository on GitHub
Who uses Jailer?
Jailer Integrations
Jailer's 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 hierarchically structured XML, topologically sorted SQL-DML and DbUnit datasets
- A demo database is included with which you can get a first impression without any configuration effort
Jailer Alternatives & Comparisons
What are some alternatives to Jailer?
Slick
It is a modern database query and access library for Scala. It allows you to work with stored data almost as if you were using Scala collections while at the same time giving you full control over when a database access happens and which data is transferred.
Spring Data
It makes it easy to use data access technologies, relational and non-relational databases, map-reduce frameworks, and cloud-based data services. This is an umbrella project which contains many subprojects that are specific to a given database.
DataGrip
A cross-platform IDE that is aimed at DBAs and developers working with SQL databases.
DBeaver
It is a free multi-platform database tool for developers, SQL programmers, database administrators and analysts. Supports all popular databases: MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server, Sybase, Teradata, MongoDB, Cassandra, Redis, etc.
Microsoft SQL Server Management Studio
It is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database. It provides tools to configure, monitor, and administer instances of SQL Server and databases. Use it to deploy, monitor, and upgrade the data-tier components used by your applications, as well as build queries and scripts.
Related Comparisons
No related comparisons found