Re: Updating Database Schema
On Jul 12, 3:31 pm, Jeff Anderson <[EMAIL PROTECTED]> wrote: > Chris wrote: > > What's the best way to update database schema? If I add a column to a > > table in my models.py and then run "manage.py syncdb", it doesn't add > > the new column in the database. > > syncdb will never issue an alter statement-- this could be devastating > on a production server with lots of data. > > You have a few options: > > * issue the alter table command yourself > * drop the table altogether and run syncdb again > * check out the django-evolution project on google code. I haven't used > it, but it is designed to handle just this. > > Good Luck! > > Jeff Anderson Thanks. I'm not sure how an add column statement would be devastating, but I can easily imagine how drop statements could wreak havoc. Chris --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~--~~~~--~~--~--~---
Re: Updating Database Schema
Chris wrote: What's the best way to update database schema? If I add a column to a table in my models.py and then run "manage.py syncdb", it doesn't add the new column in the database. syncdb will never issue an alter statement-- this could be devastating on a production server with lots of data. You have a few options: * issue the alter table command yourself * drop the table altogether and run syncdb again * check out the django-evolution project on google code. I haven't used it, but it is designed to handle just this. Good Luck! Jeff Anderson signature.asc Description: OpenPGP digital signature
Updating Database Schema
What's the best way to update database schema? If I add a column to a table in my models.py and then run "manage.py syncdb", it doesn't add the new column in the database. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~--~~~~--~~--~--~---
