Migrate-Data 1.1

Migrate-Data is a pure java and an extremely powerful enterprise data migration tool. It supports open source and commercial databases.
With Migrate-Data the user can easily extract, transform, load and integrate data from any-to-any databases. In addition the user can also perform customized data extraction from source and create customized target objects.
Migrate-Data 1.0 supports Oracle, SQL Server, DB2 UDB, MySql, PostgreSql, Ingres, Informix, Mimer SQL, MaxDB, MS Access, Flat File and Excel file as data source and Oracle, SQL Server, DB2 UDB, MySql, PostgreSql, Ingres, Informix, Mimer SQL, MaxDB as target.
Main features:
- Migrates data to target database having same or different schema from the source database
- Generates CREATE TABLE script for target table by having the selected fields from one or more tables with modified properties.
- Incorporates a query builder that helps to create SQL SELECT statement by having selected fields from one or more tables, with data filtering conditions
- Facility for parsing SQL SELECT statement and checking syntax
- Option for adding a field for generating data of type sequence or identity, along with the selected field/s from the source table/s
- Facilitates for changing target table name, field name, field type and size while extracting data from one or more tables in the source database, flat file and Excel sheet
- Facility to execute SQL SELECT statement that is stored in a file for extracting data from the source database
- Facility to paste SQL SELECT statement by copying that from out side sources for extracting data from the source database
- Incorporates Driver manager that helps to instantiate a JDBC driver dynamically at run time
- Generates DDL (Data definition language) script
- Provides syntax editor for viewing, editing and saving generated DDL script for the target database
- Provides syntax editor for viewing, editing and saving generated CREATE TABLE statement for the target table, from the selected tables and declared constraints.