You can export data directly to your target database using Exportizer Pro or Exportizer Enterprise. But anyway, if you have a third party SQL tool which can execute the script in the target database, you can export the data to a SQL script, which is the intermediate layer between your source and target databases.

Please note, that when choosing exporting to SQL, you do the things twice: first, export the data to SQL script; second, load data from the script to your destination database. Therefore, this option can be less effective, especially for large datasets or when automating the data exporting.

Export Conditions

To export from dBase to SQL script, please consider the following:

Configuring DBF to SQL Script Exporting

  1. Launch Exportizer.
  2. Register your source dBase database. It must be a folder with .dbf files. Interface can be ADO or BDE. In the latter case, you'll probably need some preparations on Windows Vista+ to get it to work. In case of ADO, you can use your own connection string (see examples) to connect the database instead of specifying just the folder name. To let you easily identify the database, give it a friendly name.

Export Steps

  1. Open the registered dBase database.
  2. Chose a table to export.
  3. Click Export button.
  4. Go to the SQL Script tab and specify a destination SQL file.
  5. Specify the export parameters: target table name, SQL statement type, target database type, file encoding and so on.
  6. Click Next and check the source-to-target field mappings.
  7. Click Export.

See also

 Opening dBase Files (.dbf)

 ADO Connection Strings Examples