private bool RunScriptByStatements(
DirectoryInfo scriptDirectory,
string overrideConnectionInfo)
{
if (scriptDirectory == null)
{
return(false);
}
bool result = false;
FileInfo[] scriptFiles = scriptDirectory.GetFiles("*.sql");
Array.Sort(scriptFiles, CompareFileNames);
foreach (FileInfo scriptFile in scriptFiles)
{
if (
(overrideConnectionInfo == null) ||
(overrideConnectionInfo.Length == 0)
)
{
overrideConnectionInfo = writeConnectionString;
}
result = AdoHelper.ExecuteBatchScript(
overrideConnectionInfo,
scriptFile.FullName);
}
return(result);
}
public bool RunScript(
FileInfo scriptFile,
String overrideConnectionInfo)
{
if (scriptFile == null)
{
return(false);
}
if (
(overrideConnectionInfo == null) ||
(overrideConnectionInfo.Length == 0)
)
{
overrideConnectionInfo = writeConnectionString;
}
if (scriptFile.FullName.EndsWith(".sql"))
{
string pathToScripts = scriptFile.FullName.Replace(".sql", string.Empty);
if (Directory.Exists(pathToScripts))
{
DirectoryInfo scriptDirectory
= new DirectoryInfo(pathToScripts);
FileInfo[] scriptFiles
= scriptDirectory.GetFiles("*.sql");
Array.Sort(scriptFiles, CompareFileNames);
foreach (FileInfo file in scriptFiles)
{
bool result = AdoHelper.ExecuteBatchScript(
overrideConnectionInfo,
file.FullName);
if (!result)
{
log.LogError("Failed with no exception running script "
+ file.FullName);
}
}
}
return(true);
}
return(false);
}
