Hi, try using liquibase. http://www.liquibase.org/ . It works very well. kind regards, Janning Am Dienstag, 16. Oktober 2007 18:38 schrieb Stanislav Raskin: > Hello everybody, > > > > I am currently running two PostgreSQL servers on two different machines. > One of them I use for development and the other one as the "real" > production server for my applications. > > While developing new versions of these applications, I of course have to > modify the database schema, including changing the definitions of views and > sql functions, creating new indexes and removing others, changing schemas > and data types in some tables, redistributing privileges and so on. Until > now, when I decided to update the applications on the production machine to > a newer version, I used to apply these changes manually, which is quite > error-prone and annoying. > > 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? > > > > Thank you very much in advance. > > > > SR -- kind regards, janning ---------------------------(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
