Copy EPiServerMail data Msg 512, Level 16, State 1, Line 1 Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. The statement has been terminated. Msg 512, Level 16, State 1, Line 1 Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. The statement has been terminated. Msg 547, Level 16, State 0, Line 1 The UPDATE statement conflicted with the FOREIGN KEY SAME TABLE constraint "FK_tblEPiServerCommonCategory_tblEPiServerCommonCategory_Parent". The conflict occurred in database "EPiServerMailDBDev", table "dbo.tblEPiServerCommonCategory", column 'intID'. The statement has been terminated. COMMIT TRANSACTION TransactionMigration
When investigating and comparing tables between the databases the target got corrupted tables.
Migration setup:
-- Set global variables SET @strSourceDB = '[EpiServerMailDBTestData]' SET @strTargetDB = '[EPiServerMailDBDev]' SET @bitMigrateCommunity = 0 SET @bitMigrateMail = 1 SET @bitDebug = 1 SET @bitRestoreRelatePlusData = 0
Ofcourse i realize that it returns several results instead of 1 but i dont get that foreign key error. And where can i change the select phrase in order to correct these errors?
The migration completes with errors.
transaction log:
Migration setup:
Any idea why or did i miss something ?