CODEWITHSUNDEEP
python-3.xfdb
Enzer
Enzer

Reputation: 11

export table from one firebird database to another

I need to export firebird database from one server to another.

like:

"IMPORT * FROM 1DB TO 2DB"

or something like that

im using python 3.11 and FDB lib

Upvotes: 1

Views: 146

Answers (1)

dtthom09
dtthom09

Reputation: 297

Export data from the first table/database and import it into the second table/database like this:

fbexport -S -V mytable -D database1.gdb -H server1 -U username -P password -F mytable.fbx
fbexport -I -V mytable -D database2.gdb -H server2 -U username -P password -F mytable.fbx -R

Upvotes: 0

Related Questions