TFDBatchMove = class(TFDComponent)
class PASCALIMPLEMENTATION TFDBatchMove : public Firedac::Stan::Intf::TFDComponent
This class implements the engine to process the data movement between different data source and destination kinds.
Use TFDBatchMove to move data between data source and data destination. TFDBatchMove introduces abstractions for the readers and writers. A reader of a data source is represented by the Reader property. A writer to a data destination is represented by the Writer property. FireDAC implements three standard reader / writer kinds:
- Text - TFDBatchMoveTextReader, TFDBatchMoveTextWriter;
- DataSet - TFDBatchMoveDataSetReader, TFDBatchMoveDataSetWriter;
- SQL - TFDBatchMoveSQLReader, TFDBatchMoveSQLWriter.
An application should assign required reader and writer to the properties, then call Execute method. To read the source data format must be known, otherwise the application may call GuessFormat method, or setup Analyze property. By default the data movement is performed between the same named source and destination fields, otherwise use Mappings collection property.
To log the data movement, including the records rejected by the writer, use LogFileAction and LogFileName properties. To get the batch moving statistic use ReadCount, WriteCount (or InsertCount, UpdateCount, DeleteCount), and ErrorCount properties.
- TFDBatchMove Sample