Sql -> h2
Bennyboy1695 opened this issue ยท 5 comments
hi i was wondering if there was any easy ways that you knew of converting the sql data for your plugin over to h2 data instead. i know theres documentation out there but as your the plugin developer i thought you would be bound to know of an easy and simple conversion tool
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
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.
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