Is there any direct method to compare tables between MySQL and PostgreSQL.Comparing should include field name, types, default values, etc; As an example below,
Below is a dump of PostgreSQL
Below is a dump of MySQL
from above example, need to get an output for in MySQL schema is missing'service_short_code' field and also it's type and if it's nullable, also 'service_desc' field not in PostgreSQL table and it's other data.
Will this be possible to do one time or any other way to do this other than copy and pasting this type of dumps in to excel file and mapping manually.