Migrate-Data (data migration tool)
v1.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.
FEATURES
1.Migrates data to target database having same or different schema from the source database
2.Generates ‘CREATE TABLE’ script for target table by having the selected fields from one or more tables with modified properties.
3.Incorporates a query builder that helps to create SQL SELECT statement by having selected fields from one or more tables, with data filtering conditions
4.Facility for parsing SQL SELECT statement and checking syntax
5.Option for adding a field for generating data of type sequence or identity, along with the selected field/s from the source table/s
6.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
7.Facility to execute SQL SELECT statement that is stored in a file for extracting data from the source database
8.Facility to paste SQL SELECT statement by copying that from out side sources for extracting data from the source database
9.Incorporates Driver manager that helps to instantiate a JDBC driver dynamically at run time
10.Generates DDL (Data definition language) script
11.Provides syntax editor for viewing, editing and saving generated DDL script for the target database
12.Provides syntax editor for viewing, editing and saving generated CREATE TABLE statement for the target table, from the selected tables and declared constraints.
Data Source
Oracle, SQL Server, DB2 UDB ,MySql, PostgreSql, Ingres, Informix, Mimer SQL, MaxDB, MS Access, Flat File, Excel file
Given one or more connection strings to SQL Server, Analysis Server, Oracle, DB2, Sybase ASE, MySQL, PostgreSQL, Informix IDS, VistaDB, ENEA Polyhedra, or MS Access databases, SqlSpec will generate documentation about all the objects in your database
Complete multi-user database solution for $149! Track contact info, dues, donations, relationships, activities, attendance, and much more. Send integrated email, print or create labels, reports, and rosters. Many customizable features. Free support!
The KilletSoft freeware program CONVERT converts dBase, CSV, SDF and MySQL data bases in the required data formats using ASCII, ANSI, Unicode and UTF8 character sets. The data can be filtered horizontal and vertically and sorted in any order.
SW tool for rapid analyzes and processing of fixed or delimited text files. Slice and dice marketing list, mailing list, firewall log, web log, voters lists and any other text file up to 300 GB or 30 million record. Do not split files - USE THEM.
Apex SQL Log is a powerful SQL database auditing and recovery tool that analyzes SQL Server`s own Transaction Log to display information on data changes