| Subject | Re: [firebird-support] How to transfer one fdb content to another? |
|---|---|
| Author | cedriz monteagudo |
| Post date | 2014-01-11T01:15:31Z |
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 <Ivan.Prenosil@...> wrote:
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.> I have a frebird database in which was copied and was updated at the
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