Thanks to all that have replied. 

@Ivan

Will it transfer the data on the whole table without overwriting the current 
data on the other database?

Cheers!



On Saturday, January 11, 2014 9:08 AM, Ivan Přenosil <[email protected]> 
wrote:
 
  
> I have a frebird database in which was copied and was updated at the 
same time. My questions is how can I transfer the content of one of the 
databases to another so that I can unify it and make it as a single file with 
all the contents of the 2 separated databases on it? They both share the same 
content, because they were duplicated and was updated at the same time but with 
different content.
 
You can directly send data from one database into another and use them e.g. 
in Insert or Update.
Inside EXECUTE BLOCK use EXECUTE STATEMENT with ON EXTERNAL.
Look at syntax and examples in FB documentation, e.g. in FB directory
C:\Program 
Files\Firebird\Firebird_2_5\doc\sql.extensions\README.execute_statement2.txt
 
Ivan

Reply via email to