Re: [GENERAL] Best practices for migrating a development database to a release database

2004-09-11 Thread Thomas F . O'Connell
One thing I used to do (and I won't necessarily claim it as a best practice) was to maintain my entire data model (tables, functions, indexes, sequences) as SQL (plus postgres extensions) CREATE statements in text files that were version controlled (via CVS). I had an entire set of utilities th

[GENERAL] Best practices for migrating a development database to a release database

2004-09-10 Thread Collin Peters
I have searched the Internet... but haven't found much relating to this. I am wondering on what the best practices are for migrating a developmemnt database to a release database. Here is the simplest example of my situation (real world would be more complex). Say you have two versions of your