/// <summary>
/// Export script to delete orphaned record
/// </summary>
/// <param name="filePath"></param>
public static void ExportScriptToDeleteOrphan(SourceDatabase sourceDatabase, DestinationDatabase destinationDatabase, string filePath)
{
//
// Initialize
StreamWriter writer = null;
try
{
writer = new StreamWriter(filePath);
}
catch (Exception excCreateStream)
{
LogService.Log.Error("Can not create stream writer at " + filePath, excCreateStream);
return;
}
//
// Write out
writer.WriteLine("USE [" + sourceDatabase.GetDatabaseName() + "]");
writer.WriteLine("GO");
foreach (ErrorRecord error in _listErrorRecords)
{
if (error.Type == ErrorType.Orphan)
{
string script = GenerateDeleteScript(destinationDatabase, sourceDatabase.GetDatabaseName(), error);
writer.WriteLine(script);
writer.WriteLine("GO");
}
}
//
// Clean
writer.Close();
}
