Re: Switching databases

2007-09-05 Thread Jacques Le Roux
De : "Kenneth Porter" <[EMAIL PROTECTED]> > --On Thursday, September 06, 2007 9:45 AM +0800 Jonathon -- Improov > <[EMAIL PROTECTED]> wrote: > > > Actually, PostgreSQL is "the reference database" only where OFBiz is > > concerned. OFBiz seems to have been developed and tested mostly with > > Pos

Re: Switching databases

2007-09-05 Thread Michael Jensen
Kenneth Porter wrote: > > I've used MySQL in the past (deploying on CentOS5) but PostgreSQL's > reputation has me leaning that way. I just have to learn how to set it > up, and how to set up an admin app similar to phpMyAdmin. > Try phpPgAdmin http://phppgadmin.sourceforge.net/ -Mike

Re: Switching databases

2007-09-05 Thread Kenneth Porter
--On Thursday, September 06, 2007 9:45 AM +0800 Jonathon -- Improov <[EMAIL PROTECTED]> wrote: Actually, PostgreSQL is "the reference database" only where OFBiz is concerned. OFBiz seems to have been developed and tested mostly with PostgreSQL, and hardly with other RDBMSs. If you're using anyt

Re: Switching databases

2007-09-05 Thread Jonathon -- Improov
> Be aware that mySQL will sometimes forget to do the right thing, and that > PostgreSQL is the reference database AFAICT, so draw your own conclusions if > its a tossup for you. Actually, PostgreSQL is "the reference database" only where OFBiz is concerned. OFBiz seems to have been developed an

Re: Switching databases

2007-09-05 Thread David E Jones
Walter Vaughan wrote: Adrian Crum wrote: Webtools->XML Import/Export Kenneth Porter wrote: I know that ofbiz comes bundled with Derby, and that ofbiz can be used with most DB's that include a JDBC connector. Are there any tools for moving data between different back ends? For example, how

Re: Switching databases

2007-09-05 Thread Walter Vaughan
Adrian Crum wrote: Webtools->XML Import/Export Kenneth Porter wrote: I know that ofbiz comes bundled with Derby, and that ofbiz can be used with most DB's that include a JDBC connector. Are there any tools for moving data between different back ends? For example, how would one move an exist

Re: Switching databases

2007-09-05 Thread Adrian Crum
Webtools->XML Import/Export Kenneth Porter wrote: I know that ofbiz comes bundled with Derby, and that ofbiz can be used with most DB's that include a JDBC connector. Are there any tools for moving data between different back ends? For example, how would one move an existing DB from Derby to

Switching databases

2007-09-05 Thread Kenneth Porter
I know that ofbiz comes bundled with Derby, and that ofbiz can be used with most DB's that include a JDBC connector. Are there any tools for moving data between different back ends? For example, how would one move an existing DB from Derby to MySQL or PostgreSQL?