Index: Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/Migration_21.1_21.2.sql =================================================================== diff -u -raeff835461b0ba9919f6aba995075d0e58fb5455 -r3b0ab5101f547768e643f3b1ee0769058ed0f348 --- Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/Migration_21.1_21.2.sql (.../Migration_21.1_21.2.sql) (revision aeff835461b0ba9919f6aba995075d0e58fb5455) +++ Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/Migration_21.1_21.2.sql (.../Migration_21.1_21.2.sql) (revision 3b0ab5101f547768e643f3b1ee0769058ed0f348) @@ -115,6 +115,16 @@ OR ase.HydraulicLocationCalculationCollectionEntity3Id = HydraulicLocationCalculationCollectionEntityId JOIN [SOURCEPROJECT].HydraulicLocationCalculationEntity USING(HydraulicLocationCalculationCollectionEntityId); +INSERT INTO HydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity ( + [HydraulicLocationCalculationCollectionEntityId], + [HydraulicLocationCalculationEntityId] +) +SELECT + [HydraulicLocationCalculationCollectionEntityId], + [HydraulicLocationCalculationEntityId] +FROM HydraulicLocationCalculationCollectionEntity +JOIN [SOURCEPROJECT].HydraulicLocationCalculationEntity USING(HydraulicLocationCalculationCollectionEntityId); + INSERT INTO HydraulicLocationEntity SELECT * FROM [SOURCEPROJECT].HydraulicLocationEntity; INSERT INTO HydraulicLocationOutputEntity SELECT * FROM [SOURCEPROJECT].HydraulicLocationOutputEntity; INSERT INTO IllustrationPointResultEntity SELECT * FROM [SOURCEPROJECT].IllustrationPointResultEntity;