[firebird-support] RE: How to transfer one fdb content to another?

[emilt]

The way I'd do it - use IBexpert or a similar tool to export the data from the 
table in question from both databases as INSERT statements, and then compare 
the scripts (winmerge or similar), isolate the differences and use the script 
to update the database.
 

 It becomes a bit trickier if you have auto-generated keys in that table, as 
you will probably have to omit the auto-generated field in the script, which 
will generate new values, and then even trickier if these are foreign keys 
somewhere else.
 

 There might be tool to do this automatically, but I don't know,
 

 Good luck :)

[firebird-support] RE: How to transfer one fdb content to another?

[emilt]

Please, explain your situation in more detail.
 

 Do you mean one-time aggregation of the data in two copies of a database, or 
do you need to constantly keep two databases with the same structure in sync?
 

 If the first, you should start with a 'diff' of the contents and then try to 
generate suitable insert/update statements to bring the missing data into one 
of the databases.
 

 If the second - you need replication.

[firebird-support] RE: How to transfer one fdb content to another?

[dice_in_trouble]

Well we have a database that we fill in with data every day. We were working 
fine, until last thursday I think (or someday this week) that someone on our 
team accidentally duplicated the .fdb file on our server, and then he updated 
one file and the other team member updated the second file at the same time. 
What we wanted to do is to combine the contents of the files (specifically on a 
single table) so that we will not re enter the files again on one of the 
databases to keep it updated.
 

 Thanks,