Stanislav Raskin wrote:
I figure there must be a better way to do so. Is there some kind of
software, which compares two database schemas (preferably two sql dumps),
and generates a script for applying differences to one of them?
What would be the best practice for applying such updates without
endangering the data and its integrity?
What Scott said, unfortunately there's no substitute for discipline here.
It's not actually possible to fully automate this (what would it do if
you merged the data in two columns for example). There are some tools to
help you though - try searching for "diff" on www.pgfoundry.org or
"pgdiff" in google.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
