Tool for copying and comparing data in Firebird databases
What does it do?
With FBCopy, you can easily copy data between Firebird tables and databases. FBCopy is a command-line tool, so you can use it inside batch scripts, cron jobs, etc. Currently, Linux and Windows versions are available, but I hope it can be built with any compiler that can build IBPP library. It has been tested and works on FreeBSD as well.
Since version 1.50, you can also compare data in different databases. It can output a simple tabular overview of different/same records, or a detailed HTML that shows each record in both databases. See manual for details.
Why use it?
I was trying to copy data from one Firebird database to another. There are a lot of nice GUI tools that do it, but they all require thay you have fast access to database. Both databases I had were on remote server, and all I had was console access via ssh. Databases were too big to copy them to my machine, pump the data, and copy back. So I had to pump on the server. There were no tools for this, so I decided to write one.
This tool uses IBPP library for database access. It supports Firebird 1.0, 1.5, 2.0 and InterBase 6 databases. It should also work with InterBase 6.5 and 7, but noone has confirmed it yet. If it works for you, please let me know. As IBPP project grows, I hope to support all database engines they do.
FBExport doesn't support ARRAY datatype yet. If you need it, please let me know. Also, dialect 1 is not supported at this time, only Dialect 3.
FBCopy is Free Software, released under Expat (a.k.a. MIT) license
Latest version can be downloaded from Firebird FAQ website.