private void mnuViewObjectScript_Click(object sender, System.EventArgs e) { if (lstResults.SelectedItems.Count == 0) { return; } ListViewItem item = lstResults.SelectedItems[0]; SqlSync.ObjectScript.ObjectScriptHelper helper = new ObjectScriptHelper(this.connData); string script = string.Empty; string desc = string.Empty; string message; string fullObjName = item.SubItems[0].Text; string name = fullObjName; string schema; InfoHelper.ExtractNameAndSchema(name, out name, out schema); switch (item.SubItems[1].Text.Trim()) { case "V": helper.ScriptDatabaseObject(SqlSync.Constants.DbObjectType.View, name, schema, ref script, ref desc, out message); break; case "P": helper.ScriptDatabaseObject(SqlSync.Constants.DbObjectType.StoredProcedure, name, schema, ref script, ref desc, out message); break; case "FN": helper.ScriptDatabaseObject(SqlSync.Constants.DbObjectType.UserDefinedFunction, name, schema, ref script, ref desc, out message); break; default: message = string.Empty; break; } if (script.Length > 0 || message.Length > 0) { ScriptDisplayForm frmDisplay; if (script.Length > 0) { frmDisplay = new ScriptDisplayForm(script, this.connData.SQLServerName, item.SubItems[0].Text); } else { frmDisplay = new ScriptDisplayForm(message, this.connData.SQLServerName, item.SubItems[0].Text); } frmDisplay.ShowDialog(); } }
private bool ScriptObject(string objectName, string schemaOwner, string type, string fullFileName, out string message) { bool success = false; string script = string.Empty; string objectTypeDesc = string.Empty; success = helper.ScriptDatabaseObject(type, objectName, schemaOwner, ref script, ref objectTypeDesc, out message); if (success) { helper.SaveScriptToFile(script, objectName, objectTypeDesc, Path.GetFileName(fullFileName), fullFileName, true, true); return(true); } else { return(false); } }