Index: Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/Migration_23.1_24.1.sql =================================================================== diff -u -r68c67ec6bb74c35eeecbf0b95983a5c780f6d008 -r9f5c6573161f18806f033b03631814b618868187 --- Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/Migration_23.1_24.1.sql (.../Migration_23.1_24.1.sql) (revision 68c67ec6bb74c35eeecbf0b95983a5c780f6d008) +++ Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/Migration_23.1_24.1.sql (.../Migration_23.1_24.1.sql) (revision 9f5c6573161f18806f033b03631814b618868187) @@ -469,6 +469,21 @@ -- WaterPressureAsphaltCoverFailureMechanismMetaEntity /* +Update specific data +*/ +UPDATE HydraulicBoundaryDataEntity +SET [HydraulicLocationConfigurationDatabaseScenarioName] = NULL, + [HydraulicLocationConfigurationDatabaseYear] = NULL, + [HydraulicLocationConfigurationDatabaseScope] = NULL, + [HydraulicLocationConfigurationDatabaseSeaLevel] = NULL, + [HydraulicLocationConfigurationDatabaseRiverDischarge] = NULL, + [HydraulicLocationConfigurationDatabaseLakeLevel] = NULL, + [HydraulicLocationConfigurationDatabaseWindDirection] = NULL, + [HydraulicLocationConfigurationDatabaseWindSpeed] = NULL, + [HydraulicLocationConfigurationDatabaseComment] = NULL +WHERE [HydraulicLocationConfigurationDatabaseComment] = "Gegenereerd door Riskeer (conform WBI2017)"; + +/* Write migration logging */ ATTACH DATABASE "{1}" AS LOGDATABASE;