Daniel - do you know much about the MDB2 XML Schema?. Would it be easy to use that in our project? One of the more painful items around here is maintaining schemas for postgres and mysql. if we add more, the burden will be bad. this is one reason why mssql support faded away. for those who don't know, MDB2 is a PEAR project which defined a database independant way to define tables, indexes, etc. see http://www.backendmedia.de/MDB2/docs/xml_schema_documentation.html -moshe Daniel Convissor wrote:
On Tue, Mar 29, 2005 at 03:54:42PM -0500, Daniel Convissor wrote:
Yet another is to have each table be a separate query file which the install script sucks up, adjusts and executes as needed.
Oh, here's a link to a similar system I put together: http://www.analysisandsolutions.com/presentations/portability/slides/create-...
--Dan