# DataTransfer.CopyRows() Method
> Version: _Available or changed with runtime version 10.0._
Copies the rows from the source table to the destination table with the fields selected with AddFields and the filters applied with AddSourceFilter, in one bulk operation in SQL.
## Syntax
```al
 DataTransfer.CopyRows()
```
## Parameters
DataTransfer
Type: datatransfer-data-type
An instance of the datatransfer-data-type data type.
## Remarks
The DataTransfer object can only be used in upgrade code and it will throw an runtime error if used outside of upgrade codeunits.
Use this method to copy data in rows of a table to rows in another table. See Transferring Data Between Tables<../../devenv-data-transfer>.
> NOTE
> Copying the SystemID and data audit<../../devenv-table-system-fields#audit> fields using CopyRows is supported in Business Central version 21.5 and later.
## Example
In this code example, you copy the PK and S3 fields in the Source table for all rows where S2 equals A and add them as new rows in the Destination table. You use AddConstantValue method to give the field D2 the value X in the inserted rows.
```al
local procedure CopyRows()
var
    dt: DataTransfer;
    src: Record Source;
    dest : Record Destination;
begin
    dt.SetTables(Database::Source, Database::Destination);
    dt.AddFieldValue(src.FieldNo("PK"), dest.FieldNo("PK"));
    dt.AddFieldValue(src.FieldNo("S3"), dest.FieldNo("D3"));
    dt.AddConstantValue('X', dest.FieldNo(D2));
    dt.AddSourceFilter(src.FieldNo("S2"), '=%1', 'A');
    dt.CopyRows();
end;
```
## Related information
datatransfer-data-type
Transferring Data Between Tables<../../devenv-data-transfer>
Getting Started with AL<../../devenv-get-started>
Developing Extensions<../../devenv-dev-overview>

Copyright (c) Microsoft Corporation. CC BY 4.0, https://creativecommons.org/licenses/by/4.0/; code samples MIT. From https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/methods-auto/datatransfer/datatransfer-copyrows-method, MicrosoftDocs/dynamics365smb-devitpro-pb at 828b6ee (2026-11-19). Changed: includes filled in, links to this site, and for agents shortened without dropping a fact. https://jonas-paprotka.de/docs/dev-itpro/developer/methods-auto/datatransfer/datatransfer-copyrows-method/
