Exporting and Importing Raw Data
Go Up to Importing and Exporting Data
Use the TIBSQL component, along with the TIBOutputRawFile and TIBInputRawFile objects to perform batch imports and exports of raw data. A raw file is the equivalent of InterBase external file output. Raw files are not limited to straight character format, so whatever structure is defined by your query is what goes in the file.
Use a SQL SELECT statement to export the data to the raw file, and an INSERT statement to import the raw data into another database.
Raw files are probably the fastest way, aside from external tables, to get data in and out of an InterBase database, although dealing with fixed-width files requires considerable attention to detail.