Thank you so much for the great responses. I had not checked out Doctrine, but will definitely look into it! I figured that there had to be some technical reason why such a plugin / core implementation already.
Thank you, Keith On Oct 24, 5:19 am, Martin Kreidenweis <[EMAIL PROTECTED]> wrote: > Hi, > > > But there doesn't seem to be any code in propel to allow you to add/ > > remove columns from an existing database. > > It doesn't have any kind of helpers to let you modify an existing > > database schema at all. > > > So because of that, you wouldn't be able to do migrations in a > > database independent way. > > Right. Thats one of the main reasons the plugin doesn't do that. :) > And it would be even harder to support YAML schema files, as they are > first translated to propel XML files by symfony. Practically no chance > of getting it to generate single ADD COLUMN statements or the like. > > I wrote the plugin to scratch some very specific itch. I don't use YAML > schema files at all currently. Instead I have the whole database modeled > in DBDesigner 4. After changing something I use dbd2propel.xsl to > convert the DBDesigner file to propel XML and then regenerate the model > (and SQL DDL). Then I practically just make a diff between the new and > the previous lib.model.schema.sql file and copy'n'paste the differences > to a new migration. So I actually have to write very little SQL by hand. > > Martin --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "symfony developers" 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-devs?hl=en -~----------~----~----~----~------~----~------~--~---
