If you're using MySQL then there's a handy tool you can use that's pretty decent for the job (and it's free :))
http://dev.mysql.com/downloads/gui-tools/5.0.html -----Original Message----- From: symfony-users@googlegroups.com [mailto:symfony-us...@googlegroups.com] On Behalf Of James Cauwelier Sent: 21 May 2009 12:03 To: symfony users Subject: [symfony-users] Re: Best Practices for Schema Changes With a small database this approach would work just fine. From time to time I have to change the schema on a database with tables as large as 6 million rows. Adding a row or an index is not someting that you do on the live database. It is just too risky and takes a long time. Not so long ago I added a column which took me 1.5 days. I am not a database expert, but maybe for larger databases replicating the database, doing the changes on the replicated databases and then switching the master would seem to be a better solution. I don 't know if it is possible to replicate between tables when the replicated database has an extra column. Maybe somebody can comment on that? James On May 20, 4:33 pm, slinky66 <tcasto...@comcast.net> wrote: > Thank you for that. We do not use Doctrine however these steps worked > for me just fine: > > 1) Made changes to existing database schema directly on the database. > In this case, I added a new column to an existing table > > 2) symfony propel-build-schema xml > > 3) symfony propel-build-model > > 4) symfony cc > > These operations affected the base classes that need to take care of > the new column that I added. > > On May 20, 10:20 am, Thibault Jouannic <tee...@gmail.com> wrote: > > > > > > > Hi, > > > If you use Doctrine, you can use migrations tools : > > >http://www.symfony-project.org/doctrine/1_2/en/07-Migrations > > > On 20 mai, 15:50, slinky66 <tcasto...@comcast.net> wrote: > > > > I have not been able to find a best practice approach in the Symfony > > > docs for dealing with > > > schema changes as it relates to rebuilding the data model. Can someone > > > give me some guidance with this scenario? > > > > Site is up and running and a few weeks later, a new column needs to be > > > added to the database. > > > > Can some one describe the steps? > > > > Thanks --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~----------~----~----~----~------~----~------~--~---