good library for comparing databases?

[mdodge-ecgrow]

Would this be a good library to compare two databases? I would like to build a backend admin page to show differences between two databases.
For example:
"There are two more rows in this db.table that are not in this db.table"
"The quantity field in for this row in table is different between db1 and db2"
etc

[taozhi8833998]

@mdodge-ecgrow, Do you want to check it in two different SQL queries or the same SQL query? The library can parse to retrieve the table and column list for the SQL, and you can compare the list for different SQL.

[mdodge-ecgrow]

Multiple different queries is fine. And can it compare data down to the row level too?

[taozhi8833998]

Currently, it can only compare different SQL queries and not compare the results of the data retrieved by the SQL.