USE NewDatabase

SET NOCOUNT ON
SET STATISTICS TIME ON
SET IDENTITY_INSERT Data ON

INSERT INTO NewDatabase.Data
(
   Id,
   TimeIn,
   TimeOut,
   WaitingTime,
   RepairTime,
   ErrorCode,
   LineName,
   MachineName,
   ModuleNo,
   LaneNo,
   ProductMode,
   ProgrameName,
   PanelNo,
   Status,
   PICName,
   MachineType,
   ActionTaken,
   TimeInsert,
   Flag,
   ProcessId
)
SELECT
   Id,
   TimeIn,
   TimeOut,
   WaitingTime,
   RepairTime,
   ErrorCode,
   LineName,
   MachineName,
   ModuleNo,
   LaneNo,
   ProductMode,
   ProgrameName,
   PanelNo,
   Status,
   PICName,
   MachineType,
   ActionTaken,
   TimeInsert,
   Flag,
   1
FROM OldDatabase.Data

SET STATISTICS TIME OFF
SET NOCOUNT OFF
SET IDENTITY_INSERT Data OFF