Subject RE: [firebird-support] Insert rows from table in other database
Author Thomas Steinmaurer

> Please help me with syntax to Insert rows from table in other database:
> INSERT INTO "customer.gdb".table
> FROM "\oldcustomer.gdb".table
> Where Name = 'David'

This isn't possible with a pure SQL statement.

But, you might be able to do that within your client
application by using the two-phase commit (2PC) protocol.

Perhaps your data access components offer something
like a data pump component (e.g. IBObject does). If
it is a one time job to move records between databases,
then grep of the available third-party tools.

InterBase DataPump is one of them.

Database Workbench has a pump facility too.

Thomas Steinmaurer
LogManager Serie - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database and MS SQL Server
Upscene Productions