Copy One table data to next table...

Step 1 . If destination table have any identity column then firstly off identity by this query

SET IDENTITY_INSERT DestinationTable ON

Step 2  Put this query in editor

 Insert into db.DestinationTable (clomunname1,clomunname2,clomunname3)
select clomunname1,clomunname2,clomunname3 from SourceTable 

.... Data Copied

Step 3  Please On its identity Column

SET IDENTITY_INSERT DestinationTable OFF