Is there a script for generating a migration SQL (postgres) file?
I only know this - Another PostgreSQL Diff Tool (it's java, though), but personally I don't trust computers that much and prefer hand-crafted update scripts.
Now similar question with answers in DBA exists:https://dba.stackexchange.com/questions/73846/postgresql-schema-diff-patch-tool
In particular it's offered the next variants:
- Flyway migration tool where comparison with other tools is presented
- difference tool in DataGrip IDE
- diff tool of liquibase