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

2014-01-12 Thread 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

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

2014-01-11 Thread 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

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

2014-01-11 Thread 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