Re: MySQL to PostgreSQL for SugarCRM

dennis, look at vtiger crm (http://www.vtiger.com)

vtiger is a fork of sugarcrm and are 100% commited to open source.
(unlike sugar, who offer the full version only for purchase)

and they actively want to support more databases.

regards,
/sak

Denis Lussier wrote:
> At EnterpriseDB we're doing a little project along these lines.   In our
> lab, and soon for our company, we are running SugarCRM on
> EDB-Postgres.   Alas you say, but SugarCRM only supports MySQL:
> 
> EDB ships a nifty java based ETL tool with our product that is 99.5%
> based on the Enhydra Octopus LGPL project.  This allows for easily
> converting schema and data from a populated MySQL SugarCRM database into
> Postgres.   Then we hacked the PHP code of SugarCRM for a couple days
> and it is now working just fine on EDB-Postgres.
> 
> I think that whenever we come across an Open Source (or even a
> commercial\proprietary product) out there that supports MySQL, but not
> PostgreSQL...  We need to work collectively as a group to make it
> shamefully simple for the project to work with PostgreSQL also. 
> SugarCRM has 250,000 downloads and every single one of those customers
> is guaranteed to be introduced to MySQL and only MySQL.
> 
> --Luss
> 
> PS1  Yes, we are going to try and work with the SugarCRM folks and get
> Postgres supported natively without customers having to hack the way we
> did to get it working.
> 
> PS2  I've hired many interns for summer and/or co-op jobs over the
> years.  The trick is to give them something interesting to do AND pay
> them a little more than they can make flipping burgers.
>