/// <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(); }