public static List <SqlServerScript> ExecuteScriptsInFolders(IEnumerable <string> folderPaths, SqlServerDatabase targetDatabase, int?maxRetries)
{
List <SqlServerScript> scripts = new List <SqlServerScript>();
foreach (string folderPath in folderPaths)
{
foreach (string fileName in Directory.EnumerateFiles(folderPath, "*.sql"))
{
SqlServerScript script = new SqlServerScript(Path.Combine(folderPath, fileName));
foreach (ISqlBatch batch in script.Batches)
{
targetDatabase.ExecuteSqlBatch(batch);
}
scripts.Add(script);
}
}
int countFailedBatches;
int previousCountFailedBatches = 0;
while (maxRetries > 0 || maxRetries == null)
{
countFailedBatches = 0;
foreach (SqlServerScript script in scripts)
{
foreach (SqlServerBatch batch in script.Batches)
{
if (batch.Executions.Last().Exception != null)
{
countFailedBatches++;
targetDatabase.ExecuteSqlBatch(batch);
}
}
}
if (countFailedBatches == previousCountFailedBatches)
{
break;
}
previousCountFailedBatches = countFailedBatches;
maxRetries--;
}
return(scripts);
}
public static List<SqlServerScript> ExecuteScriptsInFolders(IEnumerable<string> folderPaths, SqlServerDatabase targetDatabase, int? maxRetries)
{
List<SqlServerScript> scripts = new List<SqlServerScript>();
foreach (string folderPath in folderPaths)
{
foreach (string fileName in Directory.EnumerateFiles(folderPath, "*.sql"))
{
SqlServerScript script = new SqlServerScript(Path.Combine(folderPath, fileName));
foreach (ISqlBatch batch in script.Batches)
{
targetDatabase.ExecuteSqlBatch(batch);
}
scripts.Add(script);
}
}
int countFailedBatches;
int previousCountFailedBatches = 0;
while (maxRetries > 0 || maxRetries == null)
{
countFailedBatches = 0;
foreach (SqlServerScript script in scripts)
{
foreach (SqlServerBatch batch in script.Batches)
{
if (batch.Executions.Last().Exception != null)
{
countFailedBatches++;
targetDatabase.ExecuteSqlBatch(batch);
}
}
}
if (countFailedBatches == previousCountFailedBatches)
break;
previousCountFailedBatches = countFailedBatches;
maxRetries--;
}
return scripts;
}
