Tell me a tool for automatic comparison of PostgreSQL schemas on different databases. For MySQL used SQLyog. Now we are writing the migrations manually, and it is generally hard to overtake the different data in the dictionaries. Who what uses or how gets out?
UPD: We ourselves use:
a) for comparing schemes - apgdiff
b) for comparing data - LEFT JOIN%)
you can still try this script - snippets.dzone.com/posts/show/949
1. Doing Reverse Engineering One
2. For the resulting model, launch Modify, specify another as the target.
3. The resulting DDL statements are diff.
1. under Windows, under Vain’s school, it’s buggy and for a long time to cut it to that state in order to at least create a workspace.
2. Trial or ...