Prenos tHE_SetSubjContact izmedju baza

--lista constrainta
SELECT fk.name AS ConstraintName,
       t.name AS TableName
FROM sys.foreign_keys fk
JOIN sys.tables t ON fk.parent_object_id = t.object_id
WHERE fk.referenced_object_id = OBJECT_ID('tHE_SetSubjContact');
go


DECLARE @sql NVARCHAR(MAX) = '';
SELECT @sql = @sql + 'ALTER TABLE ' + QUOTENAME(t.name) +
    ' NOCHECK CONSTRAINT ' + QUOTENAME(fk.name) + ';' + CHAR(13)
FROM sys.foreign_keys fk
JOIN sys.tables t ON fk.parent_object_id = t.object_id
WHERE fk.referenced_object_id = OBJECT_ID('tHE_SetSubjContact');

PRINT @sql;  -- Prikazuje generisanu skriptu
EXEC sp_executesql @sql;  -- Izvršava generisanu skriptu
go

DELETE FROM tHE_SetSubjContact where acSubject not like ''
go

insert into Magacin55.dbo.tHE_SetSubjContact(acSubject,anNo,acActive,acName,acSurname,acMiddle,acPrefix,acUserId,acPassword,acDefLang,acATOrder,acATStock,acATCash,acATInvoice,acATCalendar,acPersonal,acAppl,adBDay,acFunction,acBankBranch,adTimeIns,anUserIns,adTimeChg,anUserChg,acWorkerContact,anUserID,acDept,acAgencySignedBy,anUserGroup,acLangID,acCerTime,acCerPub,acRegNo,anMaxRebate,acWebUserID,acLicDataBase,acProfile,acPost,acPhoto,acPIN,acSignature,acCode,acAdditPersonMark,adGDPRConfirm,acForeigner,acWeb,acLicServer,acUserLicence)
select acSubject,anNo,acActive,acName,acSurname,acMiddle,acPrefix,acUserId,acPassword,acDefLang,acATOrder,acATStock,acATCash,acATInvoice,acATCalendar,acPersonal,acAppl,adBDay,acFunction,acBankBranch,adTimeIns,anUserIns,adTimeChg,anUserChg,acWorkerContact,anUserID,acDept,acAgencySignedBy,anUserGroup,acLangID,acCerTime,acCerPub,acRegNo,anMaxRebate,acWebUserID,acLicDataBase,acProfile,acPost,acPhoto,acPIN,acSignature,acCode,acAdditPersonMark,adGDPRConfirm,acForeigner,acWeb,acLicServer,acUserLicence
from Racunovodstvo08.dbo.tHE_SetSubjContact
where acSubject not like ''
go

DECLARE @sql NVARCHAR(MAX) = '';
SELECT @sql = @sql + 'ALTER TABLE ' + QUOTENAME(t.name) +
    ' CHECK CONSTRAINT ' + QUOTENAME(fk.name) + ';' + CHAR(13)
FROM sys.foreign_keys fk
JOIN sys.tables t ON fk.parent_object_id = t.object_id
WHERE fk.referenced_object_id = OBJECT_ID('tHE_SetSubjContact');

PRINT @sql;  -- Prikazuje generisanu skriptu
EXEC sp_executesql @sql;  -- Izvršava generisanu skriptu
go