Hi, I'm relatively new to Symfony as well (I use Doctrine), and have wondered the same thing.
During development, whenever I modify the schema I find myself dropping the database, rebuilding the models, rebuilding the SQL, inserting the SQL, and then inserting my fixtures. Is there a better way to do this? During development it isn't such a big deal, but down the track when the application is in production, I obviously wouldn't want to empty the database just to add an extra field or two. Thanks very much. Regards, James Collins OM4 - Website Design and Development OM4.com.au | OM4Tourism.com 2009/12/2 dthomas-wwp <[email protected]> > I use sfPropelSqlDiffPlugin, which adds a propel:build-sql-diff task. > It works well, in general. > > There's some quirkiness to it though: If you're changing PKs or FKs, > sometimes it's not able to figure out the right order of operations, > so you may have to enter a loop of running the sql, running the task, > rinse and repeat until no more diffs exist. > > Also, it seems to have an issue with differences that consist only of > whitespace. The one example that haunts me routinely is that MySQL > enums continually appear as false positive differences. > > Those quirks aside, I'd recommend checking it out. > > -- > > You received this message because you are subscribed to the Google Groups > "symfony users" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<symfony-users%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/symfony-users?hl=en. > > > -- You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en.
