0

A database of MYSQL is migrated to Postgres. I need to check whether all the data records have been transferred correctly. Is there a way I can compare the contents of the two tables residing in two different RDBMS?

Improve this question
2
  • Export the table from both servers to text files of the same specification and definite rows ordering. Compare. Commented Dec 16, 2022 at 10:56
  • You can use mysql_fdw and compare each table one by one using a generic sql. Most probably, the operation will be slow Commented Dec 16, 2022 at 21:35

0

Reset to default