> Being in the mood of starting a flame war... Fresh served! ;)
I yet have to find a tool that does it 'right', but about every DB-IDE out there does provide some hook to manage the versioning and deployment of the sql. The simple way how it is done is a repo dir is set up on local machine and the the ddl extracted from the db is copied into it then uploaded via svn (and viceversa). This works ok for committing, but is a real pain for checking diffs. Other solutions exist, such as using intra-database versioning. There are about a hundred oracle tutorials that build packages designed to store versions of ddl and sql code in dedicated tables. The problem of course is that they are not portable... There are IDEs that use the same approach, and have a custom 'build/deploy' procedure (iirc embarcadero and cast sw tools do it). All in all, I would say this is more of a toolchain problem than one that needs to be solved via php components... My 2c Gaetano -- Components mailing list [email protected] http://lists.ez.no/mailman/listinfo/components
