Jailer 9.5

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.

Author Sourceforge
License Open Source
Price FREE
Released 2020-07-02
Downloads 1051
Filesize 31.00 MB
Requirements Java JRE 7 (or above), JDBC-driver for your RDBMS
Installation Instal And Uninstall
Keywords data extraction, data export, archive data, extract, extraction, export
Users' rating
(18 rating)
Jailer - Download Notice

Using Jailer Free Download crack, warez, password, serial numbers, torrent, keygen, registration codes, key generators is illegal and your business could subject you to lawsuits and leave your operating systems without patches. We do not host any torrent files or links of Jailer on rapidshare.com, depositfiles.com, megaupload.com etc. All Jailer download links are direct Jailer full download from publisher site or their selected mirrors.
Avoid: oem software, old version, warez, serial, torrent, Jailer keygen, crack.
Consider: Jailer full version, full download, premium download, licensed copy.

Jailer - The Latest User Reviews

Most popular Other downloads

DOSBox

0.74.3 download

DOS-emulator which uses the SDL-library to port to different platforms

Android SDK for Mac and Linux

Release 30.0.4 download

Develop applications for Android

New Version

Android SDK

Release 30.0.4 download

Develop applications for Android

New Version

CUDA for Linux

11.0.3 download

A C language development environment for CUDA-enabled GPUs

New Version

CUDA for Mac

11.0.3 download

A C language development environment for CUDA-enabled GPUs

New Version

BitNami JRubyStack

9.2.13-0-0 download

Designed to be an installer that greatly simplifies the installation of JRuby

TNTsdk

2020 B20200805 download

Helps developers to implement TNTmips related functions in other projects

King Root

4.5 download

Kingroot 4.5-Download kingroot 4.5

File Juicer for Mac OS X

4.82 download

Extract the JPEG pictures from Canon & Nikon RAW files

BitNami JRubyStack for Linux

9.2.13-0-0 download

Designed to be an installer that greatly simplifies the installation of JRuby