Subject Re: [firebird-support] Re: Trasnfer data from database to another database of firebird
Author Martijn Tonies
> For example say DB1 and DB2. DB2 is a copy of DB1. Only difference is
> that DB1 is having records and DB2 is empty. Now I am trying to write
> a query from which I can insert a particular record from DB1 to DB2. I
> have written following query
> "Insert Into [DB2].Table1 select * from Table1 where ID = 10;"
> Is it possible to cross - database access through query?
> which is supported by oracle and MS-Sqlserver. Can firebird support or
> not?

Firebird itself does not.

qli, a command line tool that comes with Firebird, does, more or less.
It has a slightly different syntax for things.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
My thoughts:
Database development questions? Check the forum!