JPumpDX Free and open source relation data migration implementation
Download

JPumpDX Ranking & Summary

JPumpDX Tags

xml migrate migration migrate data data migration database to xml

JPumpDX Description

Free and open source relation data migration implementation JPumpDX is a free and open source implementation of the best practices in relational data migration. JPumpDX uses XML as external data store.Table and record data can be migrated from one database to another, and from a database to XML and vice versa. Here are some key features of "JPumpDX": SQL bridge via JDBC, providing Record, Table and all related classes to handle instance data and meta data (Java-SQL layer): · Key generator statements (SEQUENCEs, AUTOINCREMENT columns) · Default key generator implementation (SequenceTable) · XML configurable SQL dialect · Editing data in XML without knowing the target database · Data migration · from XML to database · from database to XML · from database to database. · Automatic data type mapping, automatic value conversion · 'Serial' record migration (does not fill memory with all records to migrate). · Supports · catalogs, · schemas, · tables, · generated and 'natural' primary keys (non-numeric), · indexes, · unique constraints · foreign key constraints. · Migration · renaming catalogs, schemas, tables, columns · excluding/including catalogs, schemas, tables, columns · excluding certain data types · Export · by catalog/schema/table selection · graph of related records · configurable via XML · Import · insert or update service · record existence check · deferred foreign key definition · primary key mapping with database-defined key generators · configurable via XML · Lightweight Java-XML binding (JAXB). · Tested with eight database products. Requirements: · Java

JPumpDX Related Software