If you need to “pump” records from one data source to an other, then*TFDBatchmove is for you. Using FireDAC’s BatchMove component allows you to easily map the fields of one
query to an other, regardless if they belong to the same database/connection or two totally different ...
More...