[freeside-users] MySQL support revisited, was: DBD::mysql::db do failed: You have an error in your SQL syntax

[Ivan Kohler]

On Wed, Mar 19, 2014 at 01:56:50PM -0500, Sam Tetherow wrote:
> Is there a script that will migrate the DB from mysql to PG?

We don't have a Freeside-specific script, no.  Google for conversion 
tools.  Last we were researching this, we thought "pgloader" looked the 
most promising, but we didn't get as far as trying it with lots of 
useful data.

Once converted, dbdef-create then freeside-upgrade would probably be a 
good idea to fix up any schema differences.


In other, related news, we've recently gotten some MySQL sponsorship and 
fixed all known major MySQL problems (some special-case reports and 
features are not yet supported).  We're tenatively planning for beta 
MySQL support in 3.4 again.

We'd certainly appreciate folks with an interest in MySQL support 
grabbing a snapshot of FREESIDE_3_BRANCH from git and letting us know 
how it works for you.  Definitely more likely to pique our interest now 
than if you reported problems post-3.4.  ;)

Lastly a few folks had mentioned trying to help with MySQL sponsorship. 
Now would certainly be the time rather than waiting any longer.  We have 
a small number of sponsors who got things rolling again, but need more 
if we're going to reach a sufficient critical mass to continue 
supporting MySQL on an ongoing basis.

-- 
_ivan