Re: PEAR packageFileManager + SQL updates

Vincent Dupont wrote:

Hi, I need to be able to create update files that will : - replace Php and other files (rather simple) - do SQL insert or updates in various databases. Possibly create new tables, etc I plan to use the PEAR::PackageFileManager to update the files. However, I have no idea for the updates of the databases. Do anyone know of such a PEAR or other package in PHP? Currently, we use PEAR::MDB for db connections (mysql, MSSQL, Oracle). If I remeber well, MDB has a XML tool to generate databases and SQL scripts, but this only work(ed) in MySQL. Right?

no .. it works for all supported RDBMS. its only the reverse engineering which is limited to certain drivers ... the mysql reverse engineering works well .. the pgsql and sqlite drivers partly .. closely followed my mssql. so the answer is: MDB is your answer. I am also discussing with Manuel Lemos atm about more additions to the format to also allow for foreign and primary key support. better auto incremement support (MDB2 can use sequence or autoincrement automatically depending on what is supported). adding update support is possible but a bit of work since the tags for doing where statements may be a bit tricky to do properly. regards, Lukas