if ($testtable2["name"] == $table1["name"]){
$table2 = $testtable2;
$found = true;
break;
}
}
if (!$found){
echo("Warning: Table was not found in db2: \"" . $table1["name"] . "\".\n");
continue;
}
//Go through columns.
$columns1 = $dbconn1->getColumns($table1["name"]);
$columns2 = $dbconn2->getColumns($table1["name"]);
foreach($columns1 AS $column1){
//Check if all columns exists.
$column_text = $table1["name"] . "." . $column1["name"] . " " . $column1["type"] . "";
if ($column1["maxlength"]){
$column_text .= "(" . $column1["maxlength"] . ")";
}
$column2 = $columns2[$column1["name"]];
if (!is_array($column2)){
echo("Warning: Column does not exist on DB2: \"" . $column_text . "\".\n");
}else{
foreach($column1 AS $key => $value){
if ($column2[$key] != $value){
echo $column_text . ": " . $key . ":\"" . $value . "\" does not match on column2: " . $key . ":\"" . $column2[$key] . "\".\n";
