• This is my approach - first coping all records to destination table and using the script below to clean the source and preserve identity so the next batch run will not create duplication's at the destination. The source table holds auditing data and it's growing fast and getting big (10gb per week if I do nothing). This way I can offload the table and export the records to remote database for further investigations.

    USE [Mydatabase]

    declare @ident bigint;

    select @ident = IDENT_CURRENT('dbo.mytable')

    set @ident = @ident + 1

    truncate table dbo.mytable

    DBCC CHECKIDENT ("dbo.mytable", RESEED, @ident)

    ============================================

    Life is SQLized... :hehe: