protected void RestoreDropObjects(string type, string[] names, VEBooleanDelegateString dropAndExists)
{
foreach (string name in names)
{
Status("Dropping " + type + ": " + name);
dropAndExists(name);
}
Status("");
}
protected void RestoreCreateObject(string type, string text, string sourceSchema, string targetSchema, string ownerObject, VEBooleanDelegateString dropAndExists, ref int size, ref int count)
{
int length = text.Length;
if (text.Substring(0, length > 100 ? 100 : length).ToLower().IndexOf("create ") >= 0)
{
if (sourceSchema.Length > 0)
{
text = text.Replace(sourceSchema, targetSchema).Replace(sourceSchema.ToLower(), targetSchema);
}
targetCmd.Execute(text);
if (dropAndExists(ownerObject))
{
Memo("Memo", string.Format("Restore Schema {0}: {1, 7:n0} Bytes - {2} Restored", type, length, ownerObject));
size += length;
count++;
}
else
{
Memo("Memo", string.Format("Restore Schema {0}: {1, 7} {2} NOT CREATED {3}",
type, "ERROR", ownerObject,
SQLHandler.HasErrors ? " - See below\r\n" + SQLHandler.Errors : ""));
}
}
}
