protected virtual void WriteScript(string objectName, ExportObjectType objectType, string sql)
{
Throw.If(objectName).IsEmpty();
if (sql != null)
{
sql = sql.Trim();
}
// write sproc to file
string dir = Path.Combine(exportDirectory, objectType.ToString());
string scriptPath = Path.Combine(dir, objectName + ".sql");
if (!string.IsNullOrEmpty(sql))
{
try
{
if (!Directory.Exists(dir))
{
Directory.CreateDirectory(dir);
}
if (File.Exists(scriptPath))
{
File.SetAttributes(scriptPath, FileAttributes.Normal);
}
using (StreamWriter scriptFile = new StreamWriter(scriptPath, false))
{
scriptFile.Write(sql);
}
}
catch (Exception ex)
{
string msg = string.Format("Could not write the script file {0} to disk.",
scriptPath);
throw new SqlExporterException(msg, ex);
}
OnScriptWrittenEvent(new ScriptWrittenEventArgs(scriptPath));
}
}
protected virtual void WriteScript(string objectName, ExportObjectType objectType, string sql)
{
Throw.If(objectName).IsEmpty();
if (sql != null)
sql = sql.Trim();
// write sproc to file
string scriptPath = Path.Combine(_exportDirectory, _dbName + ".sql");
if (!string.IsNullOrEmpty(sql))
{
try
{
if (!Directory.Exists(_exportDirectory))
Directory.CreateDirectory(_exportDirectory);
if (File.Exists(scriptPath))
File.SetAttributes(scriptPath, FileAttributes.Normal);
using (StreamWriter scriptFile = new StreamWriter(scriptPath, true))
{
scriptFile.Write(sql);
scriptFile.WriteLine();
scriptFile.WriteLine();
scriptFile.WriteLine("-------------------------------------------------------------------");
scriptFile.WriteLine();
}
}
catch (Exception ex)
{
string msg = string.Format("Could not write the script file {0} to disk.",
scriptPath);
throw new SqlExporterException(msg, ex);
}
OnScriptWrittenEvent(new ScriptWrittenEventArgs(scriptPath));
}
}
