A new tool to import data into Firebird

Guacosoft.com has released XMLWizard, a new tool used to import data into Firebird databases. It supports XML, CSV and fixed-width textual files. XML import has some unique features like support for nested XML files and loading data from XML properties.

Beside importing, the tool can be used to compare the data from file against the database and cherry-pick the changes manually. More info, and a demo video can be found at XMLWizard website.

FBExport 1.70 released

FBExport is an open source command-line tool for exporting and importing data from Firebird databases. It features:

  • export and import data from Firebird databases
  • export to comma separated values (CSV) format
  • export as INSERT statements
  • use exported data as input for DML statements
  • cross platform – works on Windows and Linux
  • works with all Firebird versions (tested 1.0 – 2.1)

Here are the changes in version 1.70:

  • Slash character is no longer removed when loading statements from file
  • Username and password are read from ISC_USER and ISC_PASSWORD enviroment variables if available
  • Added header with column names to CSV export
  • Fixed bug with copying data on Windows

Download the latest version while it’s fresh 🙂