Tag: How to move rows from one table to another in SQL Server

• January 22, 2013

  Copy data from one server to another server (SQL)

  Scenario:  Server S -> Database S -> Table S       (to)           Server D->Database D-> Table D This can happen when we have updated table with current values in a Development/ Test server that we need to move over to production.  The steps below describe the T-SQL method of performing the move. –Step 1:set identity_insert DestinationTable on –Step…