Jailer

16.4.2 Database subsetting tool for Windows

Fernando Ortega

Software tool that extracts a subset of data from a larger database for testing and analysis purposes.

Database software for extracting data and removing obsolete entries.

Jailer is a free and open source data extractor app and DB tool developed by Ralf Wisser for Windows. It's powerful, portable, efficient and reliable.

The download has been tested by an editor here on a PC and a list of features has been compiled; see below.

Advertisement

Simplifies the extraction of referentially intact data

Jailer is a tool for database subsetting, schema and data browsing.

It creates small slices from your database and lets you navigate through your database following the relationships.

Jailer is ideal for creating small samples of test data or for local problem analysis with relevant production data.

It functions with PostgreSQL Oracle, MySQL, MariaDB, Microsoft SQL Server, IBM Db2, SQLite, Sybase, Amazon Redshift, Firebird and others.

Features of Jailer

  • Cleanup: Removes unnecessary data from databases.
  • Data Export: Exports data to SQL, CSV, XML and JSON formats.
  • Data Filtering: Selects data based on criteria.
  • Data Masking: Hides sensitive data with realistic, but not real, values.
  • Data Synchronization: Synchronizes data between two databases.
  • Database Backup: Backs up databases to local storage or cloud.
  • Database Comparison: Compares two databases and generates a report.
  • Database Import: Imports data from SQL, CSV, XML and JSON formats.
  • Database Search: Searches databases for specific values.
  • Documentation: Generates ER diagrams and HTML documentation.
  • Encryption: Encrypts databases with AES-256 algorithm.
  • Refactoring: Modifies existing structure of databases.
  • Reverse Engineering: Generates ER diagrams from existing databases.
  • Subsetting: Extracts and anonymizes data from large databases.
  • Validation: Validates databases for accuracy and integrity.

Compatibility and License

As Jailer is released under the Apache License v2.0 for Windows from database software, you are not required to pay a penny for this software. In fact, you're free to make copies, distribute it and for those that are technically inclined, view and edit the source code. Feel free to share it with friends.

What version of Windows can Jailer run on?

Jailer can be used on a computer running Windows 11 or Windows 10. Previous versions of the OS shouldn't be a problem with Windows 8 and Windows 7 having been tested. It comes in both 32-bit and 64-bit downloads.


Filed under:
  1. Jailer Download
  2. Free Database Software
  3. Open source and GPL software
  4. Portable Software
  5. Data Extraction Software
Jailer has been picked by our editors as very good.
Jailer has been tested for viruses and malware.
We have tested Jailer 16.4.2 against malware with several different programs. We certify that this program is clean of viruses, malware and trojans.