copy data in batches from one table another, so that transfer does not happen in a single transactions

copy_data.sql

DECLARE @BatchSize INT = 20000
declare @StartId = 0;
declare @MaxId;
select @MaxId = max(Id) from [dbo].[SOURCE] .

WHILE 1 = 1
BEGIN

    INSERT INTO [dbo].[Destination]
    SELECT *
    FROM [dbo].[SOURCE] 
    WHERE id between @StartId and @StartId + @BatchSize;

    SET @StartId = @StartId + @BatchSize
    IF @StartId > @MaxId BREAK
    
END