Re: Preserving data through db updates/changes

2006-01-19 Thread Max Battcher
Luke Skibinski Holt wrote: Absolutely - I had never thought of anything like that before. It's pretty daunting compared to the easy way (automating the dumping/reloading and manual editing of sql files). I think the implementation of such a beast would be very difficult though - there are too

Re: Preserving data through db updates/changes

2006-01-18 Thread Jeremy Dunck
On 1/18/06, Jeffrey E. Forcier <[EMAIL PROTECTED]> wrote: > > I do something similar to both Eric and Maniac, e.g. I create SQL > language files which contain ALTER TABLE and similar statements, and > apply those to a 'base' database to transform it into the most recent > version without losing

Re: Preserving data through db updates/changes

2006-01-18 Thread Jeffrey E. Forcier
I do something similar to both Eric and Maniac, e.g. I create SQL language files which contain ALTER TABLE and similar statements, and apply those to a 'base' database to transform it into the most recent version without losing data. I haven't automated it yet like Eric has, but it won't

Re: Preserving data through db updates/changes

2006-01-18 Thread Eric Walstad
Luke Skibinski Holt wrote: ... > I'm just looking for a quick way to update my models in the development > stage while keeping test data. Hey Luke, I keep sample/test data in sql files and have a script that reloads that data into my database. The script: - recreate the app's database

Re: Preserving data through db updates/changes

2006-01-18 Thread Maniac
Luke Skibinski Holt wrote: I'm just looking for a quick way to update my models in the development stage while keeping test data. I once wrote how I do it: http://groups.google.com/group/django-users/browse_frm/thread/251a42339efc79df/94ab85140ec35c97?lnk=st=3#94ab85140ec35c97

Re: Preserving data through db updates/changes

2006-01-18 Thread Julio Nobrega
Just dump the data into a file and reload it after re-creating the tables. At most, you will have to edit a few SQL fields/values to comply with the new column/table names. Doing it automated is *really* hard and I don't think it will be better (or more accurate) than just re-inserting the

Preserving data through db updates/changes

2006-01-18 Thread Luke Skibinski Holt
How probable would it be to implement a means of updating a database schema when only minor changes occur? 'minor' has to be defined, but the removal of columns or entire models could also be considered depending on their impact to the rest of the app/project. With no regard for the actual data,