public static List<SqlServerScript> ExecuteScriptsInFolder(string folderPath, SqlServerDatabase targetDatabase, int? maxRetries)
{
return
ExecuteScriptsInFolders(
new List<string> { folderPath },
targetDatabase,
maxRetries);
}
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 SqlServerDatabaseServer(string serverInstanceName)
{
_serverInstanceName = serverInstanceName;
_masterDatabase = new SqlServerDatabase(this.ConnectionString("master"));
}
public SqlServerDatabaseServer(string serverInstanceName)
{
_serverInstanceName = serverInstanceName;
_masterDatabase = new SqlServerDatabase(this.ConnectionString("master"));
}