Subject RE: [firebird-support] External File Construction
Author Alan McDonald
> 1) scripting file created by the front-end and sent to the IB Server to be
> executed via a DOS shell using the ISQL program. Uses simple Insert

OK so there ARE other servers? You are exporting from one central server,
sending files to remote servers and importing into those remote servers.

That's why I ask about replication - you can replicate in real time from one
server to all other (distributed) servers without this need for
export/email/import cycle.

If that's no good you could try exporting processed records to external
files (structure defined once at the main server, then you send out these
external files, get your remote admins to place them next to the gdb file
and execute a script of n lines (where n is the bumber of tables) which
basically does
INSERT INTO INTERNAL_TABLE(FIELDLIST) VALUES SELECT * FROM EXTERNAL TABLE;
This will be the fastest way to transport and import the records.
It also requires that the external files are defined at each location. They
can be overwritten each time you send new records out. You would also need a
mechanism to recognise that the import has completed and not import the same
file more than once.
Personally I prefer real time solutions.

Alan