private void describeMenu_Click(object sender, EventArgs e) { ssh.Connect(); DescribeOutput descOutput = ssh.Describe(listBox1.SelectedItem.ToString()); DataTable dtDescribe = new DataTable(); dtDescribe.Columns.Add("Name"); dtDescribe.Columns.Add("Type"); dtDescribe.Columns.Add("Modifiers"); dtDescribe.Columns.Add("Primary Key"); foreach (DBColumn column in descOutput.Columns) { DataRow r = dtDescribe.NewRow(); r["Name"] = column.ColumnName; r["Type"] = column.Type; r["Modifiers"] = column.Modifiers; r["Primary Key"] = column.IsPrimaryKey ? "X" : ""; dtDescribe.Rows.Add(r); } describeTable.DataSource = dtDescribe; ssh.Disconnect(); }
private List <DBColumn> GetMissingColumn(string table, SshDbWrapper sourceConnection, SshDbWrapper destinationConnection) { DescribeOutput sourceTabDescription = sourceConnection.Describe(table); DescribeOutput destinationTabDescription = destinationConnection.Describe(table); List <DBColumn> missingColumns = new List <DBColumn>(); foreach (DBColumn col in sourceTabDescription.Columns) { if (!ExistColumn(destinationTabDescription, col)) { missingColumns.Add(col); } } return(missingColumns); }