Index: Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/Migration_21.1_21.2.sql
===================================================================
diff -u -rc3625dd32e0520a6b4de25efd1a63320a2e026f3 -rabe528b93dcef6fb96dd87a0fefe63a51af0c38a
--- Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/Migration_21.1_21.2.sql	(.../Migration_21.1_21.2.sql)	(revision c3625dd32e0520a6b4de25efd1a63320a2e026f3)
+++ Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/Migration_21.1_21.2.sql	(.../Migration_21.1_21.2.sql)	(revision abe528b93dcef6fb96dd87a0fefe63a51af0c38a)
@@ -847,10 +847,9 @@
     [FailureMechanismEntityId],
     [SpecificFailurePathEntityId]
 FROM [SOURCEPROJECT].FailureMechanismEntity
-JOIN SpecificFailurePathEntity USING (AssessmentSectionEntityId)
-WHERE FailureMechanismType = 13 AND [Name] = "Macrostabiliteit buitenwaards" OR
-(FailureMechanismType = 17 AND [Name] = "Sterkte en stabiliteit langsconstructies") OR
-(FailureMechanismType = 18 AND [Name] = "Technische innovaties");
+    JOIN SpecificFailurePathEntity USING (AssessmentSectionEntityId)
+WHERE FailureMechanismType = 13
+  AND [Name] = "Macrostabiliteit buitenwaarts";
 
 INSERT INTO NonAdoptableWithProfileProbabilityFailureMechanismSectionResultEntity (
     [FailureMechanismSectionEntityId],
@@ -883,6 +882,8 @@
 FROM TempSpecificFailurePathMapping
 JOIN [SOURCEPROJECT].FailureMechanismSectionEntity USING(FailureMechanismEntityId);
 
+DROP TABLE TempSpecificFailurePathMapping;
+
 INSERT INTO SpecificFailurePathEntity (
     [AssessmentSectionEntityId],
     [Name],
@@ -915,6 +916,26 @@
 FROM [SOURCEPROJECT].FailureMechanismEntity
 WHERE FailureMechanismType = 17;
 
+CREATE TEMP TABLE TempSpecificFailurePathMapping
+(
+    'FailureMechanismEntityId' INTEGER NOT NULL,
+    'SpecificFailurePathEntityId' INTEGER NOT NULL,
+CONSTRAINT 'PK_SpecificFailurePathFailureMechanismSectionEntity' PRIMARY KEY ('FailureMechanismEntityId','SpecificFailurePathEntityId')
+);
+
+INSERT INTO TempSpecificFailurePathMapping
+(
+    [FailureMechanismEntityId],
+    [SpecificFailurePathEntityId]
+)
+SELECT
+    [FailureMechanismEntityId],
+    [SpecificFailurePathEntityId]
+FROM [SOURCEPROJECT].FailureMechanismEntity
+    JOIN SpecificFailurePathEntity USING (AssessmentSectionEntityId)
+WHERE FailureMechanismType = 17
+  AND [Name] = "Sterkte en stabiliteit langsconstructies";
+
 INSERT INTO NonAdoptableWithProfileProbabilityFailureMechanismSectionResultEntity (
     [FailureMechanismSectionEntityId],
     [IsRelevant],
@@ -946,6 +967,8 @@
 FROM TempSpecificFailurePathMapping
     JOIN [SOURCEPROJECT].FailureMechanismSectionEntity USING(FailureMechanismEntityId);
 
+DROP TABLE TempSpecificFailurePathMapping;
+
 INSERT INTO SpecificFailurePathEntity (
     [AssessmentSectionEntityId],
     [Name],
@@ -978,6 +1001,26 @@
 FROM [SOURCEPROJECT].FailureMechanismEntity
 WHERE FailureMechanismType = 18;
 
+CREATE TEMP TABLE TempSpecificFailurePathMapping
+(
+    'FailureMechanismEntityId' INTEGER NOT NULL,
+    'SpecificFailurePathEntityId' INTEGER NOT NULL,
+CONSTRAINT 'PK_SpecificFailurePathFailureMechanismSectionEntity' PRIMARY KEY ('FailureMechanismEntityId','SpecificFailurePathEntityId')
+);
+
+INSERT INTO TempSpecificFailurePathMapping
+(
+    [FailureMechanismEntityId],
+    [SpecificFailurePathEntityId]
+)
+SELECT
+    [FailureMechanismEntityId],
+    [SpecificFailurePathEntityId]
+FROM [SOURCEPROJECT].FailureMechanismEntity
+    JOIN SpecificFailurePathEntity USING (AssessmentSectionEntityId)
+WHERE FailureMechanismType = 18
+    AND [Name] = "Technische innovaties";
+
 INSERT INTO NonAdoptableWithProfileProbabilityFailureMechanismSectionResultEntity (
     [FailureMechanismSectionEntityId],
     [IsRelevant],