private string BuildAnyMissingMigrationStepsSQL(Dictionary<string, string> migrated)
{
string sql = "";
if (!migrated.ContainsKey("201305102053361")) sql += Properties.Resources._201305102053361_RemoveBetaFields;
if (!migrated.ContainsKey("201305102115428")) sql += Properties.Resources._201305102115428_RemoveRITree;
if (!migrated.ContainsKey("201305102117597")) sql += Properties.Resources._201305102117597_AddRITreeWithIndex;
if (!migrated.ContainsKey("201305240425388")) sql += Properties.Resources._201305240425388_ChangeTours; // Note: original migration broken as doesn't do anything
if (!migrated.ContainsKey("201305282325585")) sql += Properties.Resources._201305282325585_TitleLength;
if (!migrated.ContainsKey("201306040017265")) sql += Properties.Resources._201306040017265_ToursDescription;
if (!migrated.ContainsKey("201306040017265")) // this step has qualifier logic
{
if (_cnConfig.ProviderName.Equals("System.Data.?SqlClient")) // Note: original migration broken as should never be true
{
sql += Properties.Resources._201306050753190_ProgressiveLoad; // adds two sprocs
}
// even if logic in qualifier to add sprocs is not true, we still need to note this migration step has completed
sql +=
@"
INSERT INTO [MigrationHistory] (MigrationId, Model, ProductVersion)
VALUES
('201306050753190_ProgressiveLoad', CONVERT(VARBINARY(MAX), ''), 'Manual Migration');
GO
";
}
if (!migrated.ContainsKey("201306072040327")) sql += Properties.Resources._201306072040327_ToursUserMissingMaxLen; // Note: original migration broken as doesn't do anything
if (!migrated.ContainsKey("201306210425512")) sql += Properties.Resources._201306210425512_IncreaseYearPrecision;
if (!migrated.ContainsKey("201306210557399")) sql += Properties.Resources._201306210557399_RemoveBFSCachedFields;
if (!migrated.ContainsKey("201406020351501")) sql += Properties.Resources._201406020351501_MultipleEditors;
return sql;
}
