Interbase DataPump FAQ
Q. Can you please tell me which databases exactly Interbase DataPump can support?
A. We collected some statistic based on our latest survey:
And of course all Native Interbase or Firebird sources (including Yaffil clones).
Q. I getting "Unable get fields list for table XXX" then trying to get definitions or generate SQL script?
A. Your "Select Option" and "Quote Filed Names" settings are incorrect. Please set the proper values and try again.
Q. Can I pump data from my .TXT or .CSV file into my Interbase database?
A. Yes, you can. All you need is setup ODBC alias (or BDE alias if you prefer to use BDE) based on your .TXT or .CSV file and then select that alias as a source in IB DataPump.
Q. Can you build Interbase database from my Oracle/MSSQL/dBase/Paradox etc database (source)?
A. Yes, Interbase DataPump will do it easyly. Please read this document Interbase DataPump Tour for more details.
Q. How can I pump data from my ODBC source?
A. ODBC source can be accessed thru ADO using Microsoft OLE DB Provide for ODBC Drivers or thru BDE. If you have BDE installed on your PC then all ODBC sources will be automatically visible and accessible thru BDE
Q. What is the maximum number of records I can pump.
A. Till now the maximum of about 60 Millions (MSSQL, ADO connection) records pumped in one session was reported. As you can understand here is no limits.
Q. Will IB DataPump work without BDE (Borland Database Engine) installed on my PC?
A. Yes. You need BDE only if you want to pump data from BDE sources. ADO pre-installed on Windows 9x/NT/2000/ME/XP by default. To connect Interbase or Firebird direct access (native drivers) used.
Q. I need to pump data into my Interbase database from many different sources (let's say from MySQL and from set of dBase tables) - how can I do that?
A. All you need to do is to setup separate profile for each data source (in your case one for MySQl and other from dBase files) and then pump data from them.
Q. Let's say, we have following tables at the target database: Table1: DEPARTMENT (ID, NAME) Table2: EMPLOYEE (ID, DEPARTMENT_ID, NAME, SURNAME) foreign key: DEPARTMENT.ID <=> EMPLOYEE.DEPARTMENT_ID The source database looks as follows: Table1: EMPLOYEE (ID, DEPARTMENT_NAME, NAME, SURNAME) Will be possible to efficiently import the data without creating auxiliary tables or columns?
A. Yes - this is possible, please see next step by step instructions
Step 1: Create custom SQL source DEPARTMENT_NAM
This will get list of all department names from destination database
We assuming that you have generator MY_GEN in your destination table. If you do not have it you need to add one more step before INS_DEPARTMENT with following custom SQL, CREATE_MY_GEN
And one step after INS_DEPARTMENT with following custom SQL, DROP_MY_GEN
This way you will create temporary generator and drop it once you do not need it anymore.
Step 3: Create custom SQL destination INS_EMPLOYEE
Step 4: Manually set link between:
Nodes INS_DEPARTMENT, INS_EMPLOYEE (and CREATE_MY_GEN, DROP_MY_GEN if avialable) must be checked.
Step 5: Run IBPump and enjoy.
Q. How can I add records from source table which doesn't already exists in my destination table?
A. Let's say you have a table like this one
and you want insert only records with new AIRPORT.NAME values.
To accomplish this you can simply add new stored procedure to source database:
Run Intarbase DataPump and add custom SQL source:
Finally set the link between this custom SQL source and source AIRPORT table and pump data.
Q. I have Paradox database where I have tables with different passwords; since Interbase DataPump allows only setup only one password how can make it work with my database?
A. Paradox has has so-called super / master / generic password ("jIGGAe"), you can find more on the net (using www.google.com for example) and then use it to access all tables from your paradox database with this single password.