Index: Application/Ringtoets/src/Application.Ringtoets.Migration/Resources/Migration_5_17.1.sql
===================================================================
diff -u -r25395a3b821ef851dbe00bff72cde021d82931d5 -r70dc640733bde2e1641423189afb1a182af592ae
--- Application/Ringtoets/src/Application.Ringtoets.Migration/Resources/Migration_5_17.1.sql	(.../Migration_5_17.1.sql)	(revision 25395a3b821ef851dbe00bff72cde021d82931d5)
+++ Application/Ringtoets/src/Application.Ringtoets.Migration/Resources/Migration_5_17.1.sql	(.../Migration_5_17.1.sql)	(revision 70dc640733bde2e1641423189afb1a182af592ae)
@@ -98,7 +98,20 @@
     [Order] 
 FROM [SOURCEPROJECT].StochasticSoilProfileEntity;
 INSERT INTO StrengthStabilityLengthwiseConstructionSectionResultEntity SELECT * FROM [SOURCEPROJECT].StrengthStabilityLengthwiseConstructionSectionResultEntity;
-INSERT INTO SurfaceLineEntity SELECT * FROM [SOURCEPROJECT].SurfaceLineEntity;
+INSERT INTO SurfaceLineEntity
+SELECT 
+	[SurfaceLineEntityId],
+	[FailuremechanismEntityId],
+	CASE WHEN Suffix THEN [Name] || '(' || Suffix || ')' ELSE [Name] END as [Name],
+	[ReferenceLineIntersectionX],
+	[ReferenceLineIntersectionY],
+	[PointsXml],
+	[Order]
+	FROM (SELECT *, (SELECT count(*)
+                     FROM [SOURCEPROJECT].SurfaceLineEntity
+                     WHERE SSM.SurfaceLineEntityId > SurfaceLineEntityId
+                     AND SSM.Name IS Name) as Suffix
+	FROM [SOURCEPROJECT].SurfaceLineEntity SSM);
 INSERT INTO TechnicalInnovationSectionResultEntity SELECT * FROM [SOURCEPROJECT].TechnicalInnovationSectionResultEntity;
 INSERT INTO VersionEntity (
 	[VersionId],