GM - Data Reorganizer
Move, copy, modify, restructure, reorganize information inside and between multiple ODBC databases.
[Screenshots] [Release Notes]
- Unlimited number of ODBC connections to work on.
- Each ODBC connection can be used as a source, a destination or both.
- Schema tree view of connected databases.
- Cut, copy, paste and drag and drop supported inside the reorganization definition tree.
- Subtrees of the reorganization definition can be disabled by one click.
- Connection schemata can be stored into reorganization definition to be able to continue working on a reorganization definition when the DB-connections are temporarily not available.
- Multiple data modifiyng functions can be applied before assigning the value to the destination field.
- plug-in concept for value modifying functions.
- New data may be inserted or existing data may be found by flexible kriteria and updated.
- Complete Desktop remembered at application start.
- Comprehensive problem reports.
- Operation order sort by table foreign key dependencies possible.
- Direct data editing supported.
- Two reorganization definition file formats implemented.
Binary application runs on naked installations of windows 98/ME/NT/2000/XP/Vista/Win7/Win8 32 or 64 Bit. No DAO, ADO, .Net, Gdi+ or other additional libraries needed.
Example included importing flat geonames text data into a normalized world database.
Complete source code included.
Source code compiles with all Delphi versions (Delphi 5.0 or higher).
Note: To enable ODBC 64-Bit Integer support compile the source code with Delphi-6.0 or higher (The binary application in the setup has been compiled with Delphi-6.0 and therefore supports ODBC 64-Bit integers).
No third party units or components are needed to compile the source code.
Only Delphi Standard/Personal edition required to compile the source code.
- A binary format operating very fast and allowing very large reorganization definition files.
- A slower textual format with a size limitation of about 4 MB. But this can be edited with any text editor for manual modifications.
Why using ODBC for DB-Access with the Data Reorganizer?
- ODBC is a wide spread standard.
- There is no relevant DB-System without an ODBC Driver.
- ODBC does not require additional installations except for the driver.
- A naked Windows installation already has ODBC drivers for MS-Access, MS-Excel, DBase, Paradox and Text-Files installed.
- ODBC is right on top of the driver without additional Layers between them.
- There are ODBC drivers for almost all kinds of data, e.g. XML files.
- When it gets exotic, other DB-Access methods like ADO/MDAC or JDBC use ODBC by themself for the reasons given above.