Jailer 7.5.6

Sourceforge in Development / Other

Jailer screenshot

User Rating: 3.2 (31 votes)

Jailer is a tool for database subsetting and sampling, schema browsing, and rendering. 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.

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.
* Open Source. Entirely written in Java. Platform independent. DBMS agnostic.

Databases are growing in both size and complexity to meet the increasing demands of business. Applications to process the data are also increasing in size and complexity. With the growing complexity, solid testing becomes more and more important in order to assure the quality of software. Ideally we would like to test all changes against up-to-date production data, so the general practice is use a copy of the production database for all testing.

But when a database exceeds a certain size it becomes very expensive to provide full-size copies of the production database for development and testing. One solution of this problem is to have fewer full size copies of the production database than are really needed, often only one, which will be shared between the development and testing teams.

Of course this is far from optimal. Data in the database is left in an unknown state when passed from one team to the other. It takes a long time to provide a refresh of the production copy when it’s required. Always having an up-to-date production copy is almost impossible.

The databases required for development and testing rarely need to be full size, it is often easier to work on a small copy. Unfortunately it is very hard to manually extract a small subset of the production data. It is not possible to just take 10% of each table to get a 10% size database. The data in one table would not be related to the data in the other tables. It would not be referentially intact.

Jailer simplifies the extraction of referentially intact data. Once you have defined an extraction model, it can be used to extract data from the production database fast and easy whenever up-to-date test data is required.

File Size: 21.7998046875 MB License: Open Source Price: FREE
Platform: Windows 2000, Windows 2003, Windows XP, Windows Vista, Windows 7, Linux, Mac OS X
System Requirements: · Java JRE 5 or above · R-DBMS with JDBC-driver
Downloads: Total: 185 | This Month: 4 Released: 2017-11-14
Jailer Similar Software

DLL Analyzer 1.500 AlternateTools    

... list to their computer. A simple application to extract the available function names of a DLL-file. Can also be run with parameters from command line. DLL (dynamic link library) files include a variety of functions, data and other resources which are accessed by other executable files. The functions enable the .... Free download of DLL Analyzer 1.500

Marshal Integrator 2.0 RISE to Bloome Software    

... night-time synchronization purposes. Features • Define rules governing data export and import • Import database table and view definitions • Supports transfer of BLOBs (files) • Run manually or as scheduled batches backend • Run programmatically from custom solutions • Analyze tool for source and target databases • Use Marshal .... Free download of Marshal Integrator 2.0

Dragon UnPACKer 5.6.2 B268 Dragon Software    

... files in games like Quake, Unreal ...etc and extract files to anywhere you want easily. Dragon UnPACKer can also convert some formats to more common formats. .... Free download of Dragon UnPACKer 5.6.2 B268

software pick   

ApexSQL Recover 2017.01 ApexSQL Tools    

... and drop operations. Recover BLOB data as files. Extract data from database backups without restoring them. Some ... backup support, smart resource management, direct-to-database recovery, blob extraction, advanced filtering and more. ApexSQL Recover is compatible ... and user defined data type definition - BLOB extraction: Extract online BLOBs as data files - Advanced .... Free download of ApexSQL Recover 2017.01

Doxygen 1.8.12 Dimitri van Heesch    

... HTML, and Unix man pages. The documentation is extracted directly from the sources, which makes it much ... source code. 2. You can configure doxygen to extract the code structure from undocumented source files. This is very useful to quickly find your way in large source distributions. You can also visualize .... Free download of Doxygen 1.8.12

software pick   
Popular Software in Development / Other

USBDM 4.12.1.30 Peter O'Donoghue    

A debugger hardware interface for a range of Freescale microcontrollers. Free download of USBDM 4.12.1.30

Visual Paradigm for UML Standard Edition 14.2 Bsp1_20171 Visual Paradigm     update

UML diagrams, use case modeling, reverse engineering and more. Free download of Visual Paradigm for UML Standard Edition 14.2 Bsp1_20171

software pick   

.NET DataGridView Columns 1.8.9 RustemSoft    

.NET DataGridView Columns assembly for .NET 2.0, 3.0, 3.5. Free download of .NET DataGridView Columns 1.8.9

Arduino 1.8.5 Arduino    

Easy to write code and upload it to the i/o board. Free download of Arduino 1.8.5

TexturePacker 4.5.0 Andreas Loew    

A tool for sprite sheet creation and image optimization. Free download of TexturePacker 4.5.0

software pick