|
|
The biggest effort is the legacy pl/sql code (how to automatically translate current pl/sql code to mysql procedural language using dbsourcemanager).
The steps in this process would be:
1) Understand how DBSourceManager works. There is some documentation in Openbravo wiki but it will definitely require to explore the code
2) Enable mysql in dbsourcemanager and fix all issues till it installs openbravo tables and columns in the database. This should not be difficult but a relevant effort. Once it is done it should be possible to build the system on top of it but the system won't work
3) Next is to create a manually coded reference implementation in mysql for all different db_objects (triggers, functions, store procedures, views, etc.).
4) Using 3) as reference, extend the pl translator in dbsourcemanager to support mysql. This would be a difficult and very big effort
Once the database is created, the rest of the process should be much simpler and lighter.
My estimation for the whole process is several month-man. My recommendation is to wait till Openbravo replaces the legacy pl/sql (not sooner than 2013), but of course feel free to try.
Ismael |
|