Sql -> h2 about craftconomy3 HOT 5 OPEN

You want Mysql => H2 ?

from craftconomy3.

Yeah thats correct and was wondering if you knew of any ways that will make us not lose any data and have minimal downtime while the data is changed over :P

from craftconomy3.

Porting it is rather easy, H2 is simply a SQL database engine very similar to MySQL in terms of SQL commands support. There's nothing in cc3 atm doing the MySQL => H2 conversion since nobody asked for it. People usually do the other way around.

from craftconomy3.

we have been having sql issues with cc3 lately and another plugin and was going to try moving it to a h2 database to see if it solves the issue or at least temporarily fixes them otherwise we wouldn't be moving over

from craftconomy3.

What kind of issues? Probably just a question of configuration / optimization.

from craftconomy3.