May 6th, 2004, 03:12 PM
|
 |
Bug Hunter
|
|
Join Date: May 2003
Location: Transylvania (Romania)
Posts: 274
Time spent in forums: 20 h 12 m 34 sec
Reputation Power: 9
|
|
Quote: | Originally Posted by thomasj Is it possible to make a backup of individual tables in a Firebird 1.5 final database?
(Example backup only 1 table in a database with 5 tables).
Regards
Thomas |
fbexport it could be used to this job
Quote:
What does it do?
With FBExport, one can easily export/import data from/to Firebird table into a text file (actually it's a binary file). I first tought that XML format would be the way to go, but size of exported file matters, so I used my own format which uses less space.
FBExport is a command-line tool, so you can easily use it inside batch scripts. Currently, Linux and Windows versions are available, but I hope it can be built with any compiler that can build IBPP library.
Why use it?
I was trying to copy data from one Firebird database to another via external tables. The whole import/export process was needed since there was no chance of getting access to both databases at the same time, so any of those data-pump utilities was out of the question. Thus, I came up with the idea to export data into text file, copy that file to other server, and import the data into other database.
Then I had problem with null values. When exporting data into external tables, database engine turns all null values into zeroes (hex value 0). When importing back, integers become zero, dates become 17.11.1858, etc. I also tried to use CHAR for all exporting, but then, null value for integer becomes " ", or something similar, and one gets error message: Conversion error from string " ".
Instead of writing some UDFs or a lot of Stored Procedures for each table, I decided to make a tool that will do this job...
|
and page where it can be downloaded http://fbexport.sourceforge.net/
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
