Interbase DataPump Version History

Version 3.5 (14 March 2019)

Implemented Features:

• dynamic creation of the cc components so it compiles with a standard D7 (no need to install the components);
• correction of the qryFree SQL;
• the qryFree is created dynamically. Other query and IBSql could be created dynamically to clean up the dfm;
• minor adjustments of layout (buttons too close from edges...).

Version 3.4 (4 November 2002)

Implemented Features:

• Interbase 7 full support added. Please note that versions of Interbase DataPump prior to 3.4 will not be able to work with Interbase 7 correctly.
• Some interface changes were made.

Version 3.3

Implemented Features:

This version of Interbase DataPump can be found only on Interbase v 7.0 companion CD. Ironically v3.3 will not be able to work with Interbase v 7.0. Borland didn't released any test version of Interbase v 7.0 so we had no chance to run any tests of submitted version of Interbase DataPump with Interbase v 7.0.

• Ability to create custom SQL for source database added.
• Ability to create custom SQL for destination database added.
• Ability to create custom SQL for destination generators added.
• Custom SQL Wizard for destination sources added.

Features listed above gives you ability to update/insert/delete data located in destination database with data from source database. You also can execute all SQL/ DSQL statements on your destination database. Please read help or take online tour for more details.

• Generate SQL script: full support of additional (extended) BDE information added.

Now then you will generate SQL script to create Interbase/Firebird database based on your BDE source all information such as referral integrity, default values and checks will be collected and translated properly.

• Generate SQL script: detailed warnings will be created for every situation when original source can not be translated to Interbase/Firebird completely (properly).
• Generate SQL script: more detailed reports produced.
• Generate SQL script: support of Graphic, Memo (these two just an extension of Blob type fields) and Binary field types added.
• Generate SQL script: duplicated index names can be handled in three different ways.
• Pump report will show at the end detailed statistic for every step/source including how many records was processed, delete, inserted or updated physically and numbers of errors occurred.
• Support of DB/400 thru BDE (Easycom driver) added and tested. Many thanks to Ralf Grenzing for his great help and time.
• Some interface changes were made.

Fixed Bugs:

• Problem with Paradox passwords fixed.

Version 3.2

Implemented Features:

• Following command line options added:
  Usage:
  IBPump.exe "IBDataPump Profile.ibp" [/s="Source File/Alias/Connection String"] [/d="Destion File/Alias/Connection String"] [/o="Output Results File"]
  Examples:
  IBPump.exe "d:\MSSQLtoIB.ibp"
  IBPump.exe "e:\ACCESStoIB.ibp" /s="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=e:\GALLERY.MDB"
  IBPump.exe "c:\BDEtoIB.ibp" /s="BDEDEMO" /d="c:\BDEDEMO.gdb" /o="c:\results.txt"
  Now you can run Interbase DataPump and pass all params from command line.
• More message added into pump report and error and status messages now much more detailed.

Fixed Bugs:

• Few bugs (mostly minor) fixed.

Version 3.1

Implemented Features:

• TClientDataset removed (now you don't need to install MIDAS.DLL in order to define Autoincrement Fields then generating SQL script).
  This also means that you can compile IB DataPump with any version of Delphi 5 or 6.
• Bug with restoring constraints fixed (Option "Switch Off all Ref. Constraints which have a loop").

Fixed Bugs:

• Bug with BDE sources with local SQL connection (such as Paradox and dBase tables) and "Select Option"/"Quote Filed Names" now fixed. This bug is quite rare and may be found on attempt to build SQL script with "Create Generators For AutoInc Fields" option ON.
  Now proper settings for BDE sources with local SQL connection (Paradox, dBase etc.):
  Select Option = select * from "A table" and Quote Field Names is checked.
  Our big thanks to Uri Hartmann for reporting this problem and his great help.
• SQL Editor has some minor bug fixes.

Version 3.0

Implemented Features:

• Full support of ADO sources added.
• You can define your own select statements for any ADO/BDE/ODBC sources using all power of your SQL server/engine and pump data from this user-defined sources in a very same way as from standard tables.
• Update definitions feature will refresh source and destination definitions keeping relations in proper order.
• When pumping from flat files (dBase, Paradox etc.) “table mode” will be used instead of previously used “SQL mode”. This will prevent from heavy memory usage and will increase speed twice.
• IBPumpPlug.dll interface was totally rewritten to support all development tools (not just Delphi like before).
• Pumping statistic and progress indication improved together with generated output reports.
• Full support of MS SQL 2000 server thru native ADO provider added.
• SQL script generation improved and tested with wide range of SQL servers and flat files databases. You also can save script generation settings into profile.
• More options added.
• Almost all operations optimized.
• Interface changes.
• Sources available now.

Fixed Bugs:

Version 2.0.4

Implemented Features:

• "Silent Update Mode". Many thanks to Tilo Muetze from IQ Compusulting for idea and sponsorship.
• Ability to add constant expressions.
• Generate SQL Script improvements: copy indexes and primary keys from BDE sources and create generators and triggers for AutoInc fields.
• A lot of interface and some speed improvements.

Fixed Bugs:

• Memory leaks was finally found and hopefully this problem will never arise anymore.

Version 2.0.3

Implemented Features:

• Select Options added.

Fixed Bugs:

• Pump data from blob into varchar/char field. Reported by Shawn Anderson.
• Some minor bugs fixed.

Version 2.0.2

Implemented Features:

• Build SQL Script. Generates SQL script to create Interbase database based on BDE source.

Version 2.0.1

Implemented Features:

• Options "Case-insensitive fields/tables comparison" and "Remove spaces on fields/tables comparison" added. Thanks to Mark Ericksen for suggestion.

Fixed Bugs:

• Problem with Local SQL solved. Reported by Ted Stephens and Bill King.
• Problem with scaling fixed. Reported by Rodichev I.L.
• Information about Null/Not Null flags for Interbase fields fixed. Reported by Jeff Seaman.

Version 2.0

Implemented Features:

• Ability to pump data from any BDE/ODBC sources.

Fixed Bugs:

• Problem with comments "/**/" and MS Access solved. Reported by Nikolay Tarlychev.

Version 1.2.4

Implemented Features:

• Advanced tables analyzer, which allow now to find different kinds of loops.

Fixed Bugs:

• Crashing in case of loop between two and more tables. Reported by Dieter Tremel.
• Error with field charcase in dialect 3. Reported by Karsten Strobel.
• Error 'Alter trigger - List index out of bounds' fixed.

Version 1.2.1

Implemented Features:

• Small interface improvements (most important what now saved profile becomes 5 time smaller than in versions 1.1 and 1.2).

Fixed Bugs:

• Problem with loading generators trees from saved profile solved.

Version 1.2

Implemented Features:

• Ability to work with charsets and roles.
• Set links between generators is possible now.
• Problem with loops on the table is resolved.
• Minor interface improvements.

Fixed Bugs:

• Attempt to pump "COMPUTED BY" fields.
• Unable to work with charsets and roles. Reported by Kostia Malyshev.
• Wrong deletion order.
• Attempt to alter triggers for tables, which not used in pump. Reported by Kostia Malyshev.
• Problem with report output under Windows95.