SQL Перенос Configurations Sample

DELETE From AppDbConfig2.[dbo].[Configurations]
GO

Set IDENTITY_INSert AppDbConfig2.[dbo].[Configurations] ON
GO

Insert into AppDbConfig2.[dbo].[Configurations]
(Id,[Enabled],[Catalog],Code, Token, CreatedDT, ModifiedDT)
Select Id,[Enabled],[Catalog],Code, 0 , GetDate(), GEtDate()
from AppDbConfig.[dbo].[Configurations]
go

Set IDENTITY_INSert AppDbConfig2.[dbo].[Configurations] OFF
GO

DELETE From AppDbConfig2.[dbo].[Items]
GO

Set IDENTITY_INSert AppDbConfig2.[dbo].[Items] ON
GO

Insert into AppDbConfig2.[dbo].[Items]
(Id,ConfigurationId, [Enabled],[Catalog], Obj, TrCount, Code, CreatedDT, ModifiedDT )
Select Id,ConfigurationId, [Enabled],[Catalog], Obj, TrCount, Code, GetDate(), GEtDate()
from AppDbConfig.[dbo].[Items]
go

Set IDENTITY_INSert AppDbConfig2.[dbo].[Items] OFF
GO