--v2 delete from LICENSEREQUEST SET IDENTITY_INSERT licenserequest ON insert into licenserequest(LICENSEREQUESTID ,STATIONID,APPLICANT,DEPARTMENT,PHONE,NOTES,REQUESTDATA,REQUESTDATE) select LICENSEREQUESTID,0,APPLICANT,DEPARTMENT,PHONE,NOTES,REQUESTDATA,REQUESTDATE from N5wmx2197.dbo.LICENSEREQUEST SET IDENTITY_INSERT licenserequest off ----------------------------- delete from [LICENSESTORE] insert into [LICENSESTORE] select * from N5wmx2197.[dbo].[LICENSESTORE] --v1 delete from [N5Paper].[dbo].LICENSEREQUEST SET IDENTITY_INSERT [N5Paper].[dbo].licenserequest ON insert into [N5Paper].[dbo].licenserequest(LICENSEREQUESTID ,STATIONID,APPLICANT,DEPARTMENT,PHONE,NOTES,REQUESTDATA,REQUESTDATE) select LICENSEREQUESTID,0,APPLICANT,DEPARTMENT,PHONE,NOTES,REQUESTDATA,REQUESTDATE from N5.dbo.LICENSEREQUEST SET IDENTITY_INSERT [N5Paper].[dbo].licenserequest off ----------------------------- delete from [N5Paper].[dbo].[LICENSESTORE] insert into [N5Paper].[dbo].[LICENSESTORE] select * from [N5].[dbo].[LICENSESTORE]