Pump data from any ADO/BDE/ODBC sources and native Interbase/Firebird databases into Interbase/Firebird

Interbase DataPump

      v 3.0 (10 June 2002) Release

      Interbase DataPump allows you to pump data from any ADO/BDE/ODBC
sources (such as dBase, Paradox, Access, MSSQL, Sybase, Oracle, DB2 etc) and
native Interbase/Firebird databases into Interbase/Firebird databases easy,
fast and painlessly with total control over the whole process.

      You can generate SQL script to create Interbase/Firebird database
based on your ADO/BDE/ODBC source. This tool will help you to migrate from
Interbase 5.xx and older Interbase databases to the new Interbase
6.x/Firebird format. You can use it to pump data from one Interbase database
to another. A "must have" utility for all Interbase/Firebird developers and
administrators!

      This is "One Hour Solution" - in most cases it takes even less than an
hour to pump data to your Interbase database.

      What Interbase DataPump can do which other similar tools can't?

        a.. The first and very unique and important option is calculating of
proper tables' order and resolving all kinds of links between tables. This
means that tables will be processed in the order in which they are dependant
on each other. This is quite important, if you have a database with more
than 50 tables, which have a lot of referential constraints.
        b.. The utility can generate complete SQL script to create Interbase
database based on your ADO/BDE/ODBC source. This is not limited by tables
and fields structures and types, but also include indexes, primary keys,
AutoInc fields etc. and not to forget ability to select how to convert/map
source database datatypes into native Interbase/Firebird datatypes
(including all special cases such as boolean, string, blob and numeric
fields). For AutoInc fields triggers can be created together with all
necessary generators (with proper initial values!). Please take a tour to
learn all Interbase DataPump possibilities.
        c.. Ability to pump data from any ADO/BDE/ODBC sources and native
Interbase databases. Now you can master Interbase/Firebird databases from
virtually any kind of data sources without loosing even a tiny piece of
original functionality!
        d.. Options to switch on/off triggers, empty tables, control
transactions frequency, string case and much more.
        e.. It has a very wide range of settings and gives full control over
the conversion/pumping process. You can set your own relations between
source and destination tables, fields and generators, which makes program
very flexible.
        f.. 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. Note that
you can use joins, union, views etc. and all kind of special functions in
such custom SQL statements.
        g.. This tool has unique "silent mode" which gives you ability to
use this tool to update your clients databases in automatic mode. You can
use it as a plug-in for your application and call Interbase DataPump
services from your application.
        h.. Produces complete detailed report and progress indication.
        i.. Application is very fast with no overhead. By using only native
access to data sources it will provide unbeatable speed when you most need
it.
        j.. Nice and very easy to use interface. You can save all settings,
results or reports at any time and use them later!
        k.. This is free tool - you do not have to pay for using it.
        l.. Sources available!

      Take a tour
http://www.clevercomponents.com/products/datapump/dp-tour.asp

      Order Sources, Support or Custom Converting at
http://www.clevercomponents.com/products/datapump/ibdatapumporder.asp

 Download at  http://www.clevercomponents.com/downloads/index.asp
Features added in:

v 3.0

  a.. Full support of ADO sources added.
  b.. 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.
  c.. Update definitions feature will refresh source and destination
definitions keeping relations in proper order.
  d.. 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.
  e.. IBPumpPlug.dll interface was totally rewritten to support all
development tools (not just Delphi like before).
  f.. Pumping statistic and progress indication improved together with
generated output reports.
  g.. Full support of MS SQL 2000 server thru native ADO provider added.
  h.. 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.
  i.. More options added.
  j.. Almost all operations optimized.
  k.. Interface changes.
  l.. Sources available now.
Bugs fixed since:

v 2.0.4

  a.. Memory leaks was finally found and hopefully this problem will never
arise anymore.
Our very best regards,
CleverComponents Team
www.CleverComponents.com
i...@CleverComponents.com