Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | ||||||||||
| ID | |||||||||||
| 0006071 | |||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | ||||||
| feature request | [Openbravo ERP] A. Platform | major | have not tried | 2008-11-19 16:01 | 2011-10-19 21:48 | ||||||
| Reporter | pjuvara | View Status | public | ||||||||
| Assigned To | iciordia | ||||||||||
| Priority | normal | Resolution | open | Fixed in Version | |||||||
| Status | acknowledged | Fix in branch | Fixed in SCM revision | ||||||||
| Projection | none | ETA | none | Target Version | |||||||
| OS | Any | Database | Any | Java version | |||||||
| OS Version | Database version | Ant version | |||||||||
| Product Version | SCM revision | ||||||||||
| Review Assigned To | |||||||||||
| Web browser | |||||||||||
| Modules | Core | ||||||||||
| Regression level | |||||||||||
| Regression date | |||||||||||
| Regression introduced in release | |||||||||||
| Regression introduced by commit | |||||||||||
| Triggers an Emergency Pack | No | ||||||||||
| Summary | 0006071: MySQL support | ||||||||||
| Description | Support for MySQL as additional RDBMS in addtion to Oracle and PostgreSQL | ||||||||||
| Tags | ReleaseCandidate | ||||||||||
| Attached Files | |||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0041944) jrtejada (reporter) 2011-10-19 20:35 |
What components are involved in the migration? I'd like to help in this implementation Regards |
|
(0041945) iciordia (manager) 2011-10-19 21:48 |
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 |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2008-11-19 16:01 | pjuvara | New Issue | |
| 2008-11-19 16:01 | pjuvara | Assigned To | => rafaroda |
| 2008-11-19 16:01 | pjuvara | sf_bug_id | 0 => 2314993 |
| 2008-11-19 16:01 | pjuvara | Regression testing | => No |
| 2008-11-20 08:39 | rafaroda | Assigned To | rafaroda => pjuvara |
| 2008-11-26 17:25 | pjuvara | Sticky Issue | No => Yes |
| 2008-11-26 17:36 | pjuvara | Tag Attached: ReleaseCandidate | |
| 2008-11-26 17:37 | pjuvara | Status | new => acknowledged |
| 2008-11-26 17:39 | pjuvara | Sticky Issue | Yes => No |
| 2009-05-22 19:33 | pjuvara | Assigned To | pjuvara => iciordia |
| 2011-10-19 20:35 | jrtejada | Note Added: 0041944 | |
| 2011-10-19 20:36 | jrtejada | Issue Monitored: jrtejada | |
| 2011-10-19 21:48 | iciordia | Note Added: 0041945 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |