A useful tool for comparing two schemas is Another PostgreSQL Diff Tool (apgdiff).
I use it for upgrade scripts. Does my "upgrade schema version x to y" script produce the same schema as my "create schema version y from scratch" script? Apgdiff helps me pin point any differences and correct them.
No comments:
Post a Comment