use Premises --база скотрой работает, так же подрубить отношения нужно при выполнении

declare
@CodeTown decimal, @CodeStreet smallint, @NumDigit int, @NumAlfa varchar(10),
@NewCodeTown decimal, @NewCodeStreet smallint, @NewNumDigit int, @NewNumAlfa varchar(10)

set @CodeTown = 3401000000
set @CodeStreet = 1421
set @NumDigit = 1
set @NumAlfa =  '/5 корп.1-2'

SET @NewCodeTown = 3401000000 --дом в который переносится
SET @NewCodeStreet = 1421
SET @NewNumDigit = 1
SET @NewNumAlfa = '/5 корпус 1'

ALTER TABLE Premises.dbo.LiterCost noCHECK CONSTRAINT PK_LiterCost

/*
SET IDENTITY_INSERT Premises_from_backup.dbo.Titul_R ON

insert into dbo.Titul_R(CodeTown, CodeStreet, NumDigit, NumAlfa, PartTown, LandReg, CodeFund, CodeOF, NumInvent, NumReestr, NumKadastr, NumEKON, Tier, Shelving,
               Shelf, AppObject, FactObject, FlagNoBuild, FlagMonument, RemMonument, DateInv, DateRTI, DateEKON, DateEnd, RemarkEnd, FlagArrest, SpecMark, Remark,
               Fiscal, FK_ReestrLiter, kvartal, aPK, BarCode, Flag, TmpInvNum, aPK_2, BlokAdress, tmpAlpha, AngleStreet, DescObject, FromNew, NumInventGos, StreetADV, PK,
               PartTown3ADV, PartTown4ADV, FK_ReestrInvD, FK_InventD, UNBTI, TPAvar, DateAvar, SQ_FRS, FRS_No, FlFoto, FlSpr, Flhz, FlSpr_dop, FlSnos, kad_date,
               kad_vipiskanum, Liters, PK_1)
select @NewCodeTown, @NewCodeStreet, @NewNumDigit, @NewNumAlfa, PartTown, LandReg, CodeFund, CodeOF, NumInvent, NumReestr, NumKadastr, NumEKON, Tier, Shelving,
               Shelf, AppObject, FactObject, FlagNoBuild, FlagMonument, RemMonument, DateInv, DateRTI, DateEKON, DateEnd, RemarkEnd, FlagArrest, SpecMark, Remark,
               Fiscal, FK_ReestrLiter, kvartal, aPK, BarCode, Flag, TmpInvNum, aPK_2, BlokAdress, tmpAlpha, AngleStreet, DescObject, FromNew, NumInventGos, StreetADV, PK,
               PartTown3ADV, PartTown4ADV, FK_ReestrInvD, FK_InventD, UNBTI, TPAvar, DateAvar, SQ_FRS, FRS_No, FlFoto, FlSpr, Flhz, FlSpr_dop, FlSnos, kad_date,
               kad_vipiskanum, Liters, PK_1
from dbo.Titul_R
where CodeTown = @CodeTown and CodeStreet = @CodeStreet and numdigit = @NumDigit and numalfa = @NumAlfa --and TmpInvNum = @TmpInvNum
SET IDENTITY_INSERT Premises.dbo.Titul_R OFF*/



ALTER TABLE Premises.dbo.LiterApart noCHECK CONSTRAINT PK_LiterApart
ALTER TABLE Premises.dbo.LiterApart noCHECK CONSTRAINT FK_LiterApart_Liter --отрубает проверку вставки ключей что бы тригер не выебывался

SET IDENTITY_INSERT Premises.dbo.literapart ON --врубает возможность для вставки квартир в дом

insert into dbo.literapart (CodeTown, CodeStreet, NumDigit, NumAlfa, OrdLiter, ApartDigit, ApartAlfa, TypeApart, LandReg, CodeApart, CodeFund, NumReestr, DescApart, CntLive, YearPriv, CostYear, CostValid, CostRest, BlnsFull, BlnsRest, WearApart, RemItself, FlagArrest, FlagComfort, DateRTI, DateEnd, RemarkEnd, Remark, Fiscal, SpecMark, FromNew, CadastralNum, GroupComunal, PK, CadastralNumNew, TpAvar, DateAvar, SQ_FRS, FRS_No, FlSpr, Flhz, FlSpr_dop, kad_date, kad_vipiskanum)
select @NewCodeTown, @NewCodeStreet, @NewNumDigit, @NewNumAlfa, OrdLiter, ApartDigit, ApartAlfa, TypeApart, LandReg, CodeApart, CodeFund, NumReestr, DescApart, CntLive, YearPriv, CostYear, CostValid, CostRest, BlnsFull, BlnsRest, WearApart, RemItself, FlagArrest, FlagComfort, DateRTI, DateEnd, RemarkEnd, Remark, Fiscal, SpecMark, FromNew, CadastralNum, GroupComunal, PK, CadastralNumNew, TpAvar, DateAvar, SQ_FRS, FRS_No, FlSpr, Flhz, FlSpr_dop, kad_date, kad_vipiskanum
from dbo.literapart
where CodeTown = @CodeTown and CodeStreet = @CodeStreet and numdigit = @NumDigit and numalfa = @NumAlfa

SET IDENTITY_INSERT Premises.dbo.literapart OFF --вырубает duh...

ALTER TABLE Premises.dbo.LiterApart CHECK CONSTRAINT PK_LiterApart
ALTER TABLE Premises.dbo.LiterApart CHECK CONSTRAINT FK_LiterApart_Liter --врубает ключи

insert into dbo.apartroom (CodeTown, CodeStreet, NumDigit, NumAlfa, OrdLiter, ApartDigit, ApartAlfa, TypeApart, LiterRoom, RoomFloor, RoomDigit, RoomAlfa, TypeRoom, LandReg, CodeRoom, DescRoom, HeightRoom, Formula, AreaTotal, AreaBase, AreaSub, AreaOther, AreaGeneral, AreaItself, Partition, RemPartition, Ceiling, RemCeiling, Walking, RemWalking, Window, RemWindow, Door, RemDoor, Facing, RemFacing, Remark, Fiscal, FromNew, AreaSubGeneral, DescFloor, flooralfa)
select @NewCodeTown, @NewCodeStreet, @NewNumDigit, @NewNumAlfa, OrdLiter, ApartDigit, ApartAlfa, TypeApart, LiterRoom, RoomFloor, RoomDigit, RoomAlfa, TypeRoom, LandReg, CodeRoom, DescRoom, HeightRoom, Formula, AreaTotal, AreaBase, AreaSub, AreaOther, AreaGeneral, AreaItself, Partition, RemPartition, Ceiling, RemCeiling, Walking, RemWalking, Window, RemWindow, Door, RemDoor, Facing, RemFacing, Remark, Fiscal, FromNew, AreaSubGeneral, DescFloor, flooralfa
from dbo.apartroom
where CodeTown = @CodeTown and CodeStreet = @CodeStreet and numdigit = @NumDigit and numalfa = @NumAlfa

insert into dbo.LiterCost (CodeTown, CodeStreet, NumDigit, NumAlfa, OrdLiter, PartLiter, CodeCost, ValueCost, Fiscal)
select @NewCodeTown, @NewCodeStreet, @NewNumDigit, @NewNumAlfa, OrdLiter, PartLiter, CodeCost, ValueCost, Fiscal
from dbo.LiterCost
where CodeTown = @CodeTown and CodeStreet = @CodeStreet and numdigit = @NumDigit and numalfa = @NumAlfa

insert into dbo.LiterWear (CodeTown, CodeStreet, NumDigit, NumAlfa, OrdLiter, OrdWg, LevelWg, GrpGroup, CodeGroup, GrpConstr, CodeConstr, RemWg, StateWg, WgEl5, WgEl6, WgEl7, WgEl8, WgEl9, Token, Fiscal, FromNew)
select @NewCodeTown, @NewCodeStreet, @NewNumDigit, @NewNumAlfa, OrdLiter, OrdWg, LevelWg, GrpGroup, CodeGroup, GrpConstr, CodeConstr, RemWg, StateWg, WgEl5, WgEl6, WgEl7, WgEl8, WgEl9, Token, Fiscal, FromNew
from dbo.LiterWear
where CodeTown = @CodeTown and CodeStreet = @CodeStreet and numdigit = @NumDigit and numalfa = @NumAlfa

insert into dbo.LiterRoom(CodeTown, CodeStreet, NumDigit, NumAlfa, OrdLiter, RoomFloor, RoomDigit, RoomAlfa, TypeRoom, LandReg, CodeRoom, DescRoom, HeightRoom, Formula, AreaTotal, AreaBase, AreaSub, AreaOther, AreaGeneral, AreaItself, Partition, RemPartition, Ceiling, RemCeiling, Walking, RemWalking, Window, RemWindow, Door, RemDoor, Facing, RemFacing, Remark, Fiscal, FromNew, CadastralNum, flooralfa)
select @NewCodeTown, @NewCodeStreet, @NewNumDigit, @NewNumAlfa, OrdLiter, RoomFloor, RoomDigit, RoomAlfa, TypeRoom, LandReg, CodeRoom, DescRoom, HeightRoom, Formula, AreaTotal, AreaBase, AreaSub, AreaOther, AreaGeneral, AreaItself, Partition, RemPartition, Ceiling, RemCeiling, Walking, RemWalking, Window, RemWindow, Door, RemDoor, Facing, RemFacing, Remark, Fiscal, FromNew, CadastralNum, flooralfa
from dbo.LiterRoom
where CodeTown = @CodeTown and CodeStreet = @CodeStreet and numdigit = @NumDigit and numalfa = @NumAlfa


insert into dbo.LiterFile ( CodeTown, CodeStreet, NumDigit, NumAlfa, OrdLiter, TypeDoc, OrdDoc, NameDoc, ScaleDoc, CountDoc, NameFile, ImageDoc, Remark, Fiscal, DateReg, DateDoc, OwnDoc, FromNew)
select @NewCodeTown, @NewCodeStreet, @NewNumDigit, @NewNumAlfa, OrdLiter, TypeDoc, OrdDoc, NameDoc, ScaleDoc, CountDoc, NameFile, ImageDoc, Remark, Fiscal, DateReg, DateDoc, OwnDoc, FromNew
from dbo.LiterFile
where CodeTown = @CodeTown and CodeStreet = @CodeStreet and numdigit = @NumDigit and numalfa = @NumAlfa


--SET IDENTITY_INSERT Premises_from_backup.dbo.liter ON

insert into dbo.Liter (CodeTown, CodeStreet, NumDigit, NumAlfa, OrdLiter, TypeLiter, ParentLiter, LandReg, CodeLiter, DescLiter, PlanLiter, LengthLiter, WidthLiter, HeightLiter, AreaLiter, AreaBuild, CubicLiter, Formula, NumBook, NumTome, NumTable, NumZone, NumGraph, CostUPVS, TokenUPVS, CorrectUPVS, DimUPVS, Capital, TypeFace, CubicAreaA, CubicAreaB, CostYear, CostValid, CostRest, CostArea, BlnsFull, BlnsRest, WearLiter, FlagItself, FlagNoBuild, NumEKON, NumProject, YearBuild, YearExpl, TypeEquip, YearEquip, YearRepair, YearDestroy, RemDestroy, FloorUp, FloorDn, FlagCellar, FlagPlinth, FlagAttic, FlagMezonin, CountStairs, AreaStairs, Remark, Fiscal, CubicInRoot, PartOfParentLiter, PlanNum, NumInvent, BlnsDate, DateFAKON, YearBegin, NameTp, FromNew, StockAlfa, CadastralNum, DegreeReadiness, NeformalAdress, Korpus, Stroenie, Stockstr, PK, CadastralNumNew, typezdanie, kad_date, kad_vipiskanum, DopInf, Download, Formula1, AreaS)
select @NewCodeTown, @NewCodeStreet, @NewNumDigit, @NewNumAlfa, OrdLiter, TypeLiter, ParentLiter, LandReg, CodeLiter, DescLiter, PlanLiter, LengthLiter, WidthLiter, HeightLiter, AreaLiter, AreaBuild, CubicLiter, Formula, NumBook, NumTome, NumTable, NumZone, NumGraph, CostUPVS, TokenUPVS, CorrectUPVS, DimUPVS, Capital, TypeFace, CubicAreaA, CubicAreaB, CostYear, CostValid, CostRest, CostArea, BlnsFull, BlnsRest, WearLiter, FlagItself, FlagNoBuild, NumEKON, NumProject, YearBuild, YearExpl, TypeEquip, YearEquip, YearRepair, YearDestroy, RemDestroy, FloorUp, FloorDn, FlagCellar, FlagPlinth, FlagAttic, FlagMezonin, CountStairs, AreaStairs, Remark, Fiscal, CubicInRoot, PartOfParentLiter, PlanNum, NumInvent, BlnsDate, DateFAKON, YearBegin, NameTp, FromNew, StockAlfa, CadastralNum, DegreeReadiness, NeformalAdress, Korpus, Stroenie, Stockstr, PK, CadastralNumNew, typezdanie, kad_date, kad_vipiskanum, DopInf, Download, Formula1, AreaS
from dbo.Liter
where CodeTown = @CodeTown and CodeStreet = @CodeStreet and numdigit = @NumDigit and numalfa = @NumAlfa

--SET IDENTITY_INSERT Premises_from_backup.dbo.liter OFF

insert into dbo.apartown (CodeTown, CodeStreet, NumDigit, NumAlfa, OrdLiter, ApartDigit, ApartAlfa, TypeApart, OrdOwn, CodeOwn, LiveTown, TypeProp, Divident, Divisor, CouseBgn, DateBgn, CouseEnd, DateEnd, Remark, Fiscal, FromNew, NameSvodFlat, Download)
select @NewCodeTown, @NewCodeStreet, @NewNumDigit, @NewNumAlfa, OrdLiter, ApartDigit, ApartAlfa, TypeApart, OrdOwn, CodeOwn, LiveTown, TypeProp, Divident, Divisor, CouseBgn, DateBgn, CouseEnd, DateEnd, Remark, Fiscal, FromNew, NameSvodFlat, Download
from dbo.apartown
where CodeTown = @CodeTown and CodeStreet = @CodeStreet and numdigit = @NumDigit and numalfa = @NumAlfa

insert into dbo.apartdoc (CodeTown, CodeStreet, NumDigit, NumAlfa, OrdLiter, ApartDigit, ApartAlfa, TypeApart, OrdOwn, OrdDoc, DocGNI, LandReg, DocCode, DescDoc, NumDoc, DateDoc, GiveDoc, Remark, Fiscal, FromNew)
select @NewCodeTown, @NewCodeStreet, @NewNumDigit, @NewNumAlfa, OrdLiter, ApartDigit, ApartAlfa, TypeApart, OrdOwn, OrdDoc, DocGNI, LandReg, DocCode, DescDoc, NumDoc, DateDoc, GiveDoc, Remark, Fiscal, FromNew
from dbo.apartdoc
where CodeTown = @CodeTown and CodeStreet = @CodeStreet and numdigit = @NumDigit and numalfa = @NumAlfa

insert into dbo.titulown (CodeTown, CodeStreet, NumDigit, NumAlfa, OrdOwn, CodeOwn, LiveTown, TypeProp, Divident, Divisor, CouseBgn, DateBgn, CouseEnd, DateEnd, Remark, Fiscal, FromNew, Download)
select @NewCodeTown, @NewCodeStreet, @NewNumDigit, @NewNumAlfa, OrdOwn, CodeOwn, LiveTown, TypeProp, Divident, Divisor, CouseBgn, DateBgn, CouseEnd, DateEnd, Remark, Fiscal, FromNew, Download
from dbo.titulown
where CodeTown = @CodeTown and CodeStreet = @CodeStreet and numdigit = @NumDigit and numalfa = @NumAlfa

insert into dbo.tituldoc (CodeTown, CodeStreet, NumDigit, NumAlfa, OrdOwn, OrdDoc, DocGNI, LandReg, DocCode, DescDoc, NumDoc, DateDoc, GiveDoc, Remark, Fiscal, FromNew)
select @NewCodeTown, @NewCodeStreet, @NewNumDigit, @NewNumAlfa, OrdOwn, OrdDoc, DocGNI, LandReg, DocCode, DescDoc, NumDoc, DateDoc, GiveDoc, Remark, Fiscal, FromNew
from dbo.tituldoc
where CodeTown = @CodeTown and CodeStreet = @CodeStreet and numdigit = @NumDigit and numalfa = @NumAlfa


--SET IDENTITY_INSERT Premises_from_backup.dbo.LiterCost OFF
--SET IDENTITY_INSERT Premises_from_backup.dbo.LiterWear OFF
--SET IDENTITY_INSERT Premises_from_backup.dbo.LiterRoom OFF
--SET IDENTITY_INSERT Premises_from_backup.dbo.LiterFile OFF
ALTER TABLE Premises.dbo.LiterCost CHECK CONSTRAINT PK_LiterCost