zaher/fbforceexport

Firebird Force Export Data to CSV file

fbforceexport

Firebird Force Export Data to CSV file

If you have database currpted, this simple tool, ver simple to export all tables you defined it in tables.txt to data folder as csv. It not fix the database, it just bypass the error when can not fetch the data, as possible this simple tool.

Have fun :P

Usage

To run it with embed firebird sql you need "fbembed.dll" in the same folder of exe in subfolder "d:/myproject/fb/fbembed.dll".

open new file "tables.txt" and put your tables want to export it

AccLists
AccObjects
AccTotals
Accounts

Compile

You need minilib from https://sourceforge.net/p/minilib/

fbforceexport's Issues

hi Unable to compile?

not run

suggest

Consider exporting to binary and then importing to firebird db, because CSV is not good for blob data.

hi How are you

Thank you very much. I've exported 150 grams of CSV files containing blob data, but I'm frustrated that I can't import new DB with a lot of tools.Because they both thought the CSV format was incorrect.Do you have a way to import these CSV files?

CREATE TABLE ATTACHMENT
(
JOB_FILE_ID integer NOT NULL,
LINE_NO integer NOT NULL,
FILE_NAME LONG_TEXT,
FILE_SIZE decimal(10,0),
ATTACHMENT BINARY_DATA
);

GRANT DELETE, INSERT, REFERENCES, SELECT, UPDATE
ON ATTACHMENT TO SYSDBA WITH GRANT OPTION;

the test.csv down https://www.dropbox.com/s/sv2elc4s7vlhbq0/test.csv?dl=0

thank you

thank you

not Compile, I've put the fbembedd.dll in the fb folder

Compile Project, Mode: Release, Target: fpexport.exe: Exit code 1, Errors: 1
fpexport.lpr(10,10) Fatal: Cannot find mncFirebird used by fpexport of the Project Inspector.

hi lpr lpi not found

export.lpi
export.lpr
Hello there is no two files in your code?

bug

tables.txt
SEA_EXPORT_BOOKING_HISTORY

But the procedure put them to think that this is the two tables are

SEA_EXPORT_BOOKING_H
and
ISTORY