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.
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:
- Jailer Download
- Free Database Software
- Open source and GPL software
- Portable Software
- Data Extraction Software