Index: Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/Migration_21.1_21.2.sql
===================================================================
diff -u -rabe528b93dcef6fb96dd87a0fefe63a51af0c38a -r3393dfce6425b5b1a2f280c368180c9d7d4ab6cc
--- Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/Migration_21.1_21.2.sql	(.../Migration_21.1_21.2.sql)	(revision abe528b93dcef6fb96dd87a0fefe63a51af0c38a)
+++ Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/Migration_21.1_21.2.sql	(.../Migration_21.1_21.2.sql)	(revision 3393dfce6425b5b1a2f280c368180c9d7d4ab6cc)
@@ -800,7 +800,7 @@
 FROM [SOURCEPROJECT].WaveImpactAsphaltCoverWaveConditionsCalculationEntity;
 
 INSERT INTO SpecificFailurePathEntity (
-[AssessmentSectionEntityId],
+    [AssessmentSectionEntityId],
     [Name],
     [Code],
     [Order],
@@ -831,26 +831,6 @@
 FROM [SOURCEPROJECT].FailureMechanismEntity
 WHERE FailureMechanismType = 13;
 
-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 = 13
-  AND [Name] = "Macrostabiliteit buitenwaarts";
-
 INSERT INTO NonAdoptableWithProfileProbabilityFailureMechanismSectionResultEntity (
     [FailureMechanismSectionEntityId],
     [IsRelevant],
@@ -872,18 +852,6 @@
     NULL
 FROM [SOURCEPROJECT].MacroStabilityOutwardsSectionResultEntity;
 
-INSERT INTO SpecificFailurePathFailureMechanismSectionEntity (
-    [SpecificFailurePathEntityId],
-    [FailureMechanismSectionEntityId]
-)
-SELECT
-    [SpecificFailurePathEntityId],
-    [FailureMechanismSectionEntityId]
-FROM TempSpecificFailurePathMapping
-JOIN [SOURCEPROJECT].FailureMechanismSectionEntity USING(FailureMechanismEntityId);
-
-DROP TABLE TempSpecificFailurePathMapping;
-
 INSERT INTO SpecificFailurePathEntity (
     [AssessmentSectionEntityId],
     [Name],
@@ -916,26 +884,6 @@
 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],
@@ -957,18 +905,6 @@
     NULL
 FROM [SOURCEPROJECT].StrengthStabilityLengthwiseConstructionSectionResultEntity;
 
-INSERT INTO SpecificFailurePathFailureMechanismSectionEntity (
-    [SpecificFailurePathEntityId],
-    [FailureMechanismSectionEntityId]
-)
-SELECT
-    [SpecificFailurePathEntityId],
-    [FailureMechanismSectionEntityId]
-FROM TempSpecificFailurePathMapping
-    JOIN [SOURCEPROJECT].FailureMechanismSectionEntity USING(FailureMechanismEntityId);
-
-DROP TABLE TempSpecificFailurePathMapping;
-
 INSERT INTO SpecificFailurePathEntity (
     [AssessmentSectionEntityId],
     [Name],
@@ -1001,26 +937,6 @@
 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],
@@ -1042,6 +958,27 @@
     NULL
 FROM [SOURCEPROJECT].TechnicalInnovationSectionResultEntity;
 
+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 fme
+JOIN SpecificFailurePathEntity sfpe USING (AssessmentSectionEntityId)
+WHERE (fme.[FailureMechanismType] = 13 AND sfpe.[Name] = "Macrostabiliteit buitenwaarts") OR
+(fme.[FailureMechanismType] = 17 AND sfpe.[Name] = "Sterkte en stabiliteit langsconstructies") OR
+(fme.[FailureMechanismType] = 18 AND sfpe.[Name] = "Technische innovaties");
+
 INSERT INTO SpecificFailurePathFailureMechanismSectionEntity (
     [SpecificFailurePathEntityId],
     [FailureMechanismSectionEntityId]