Community mailing list archives

community@mail.odoo.com

Re: Conversion from mysql to postgreSQL

by
saintcyrwin
- 02/25/2015 14:31:00

Dear Roman, thanks for your proposition. Please how can i do to realize it. It's means migrate only  all master / preference data.
Best regards
Saint Cyr

Le 25 févr. 2015 17:32, "Roman Gurinovich" <roman.gurinovich@xpansa.com> a écrit :
Dear Cyr, 

like Andre wrote, that is mainly manual work, even if some automation tool will be selected. Reason - exact fields and workflows mapping is needed. So simple CSV sync will work for you too. You can utilize next approach:

1. Migrate all master / reference data : Customers, Partners, Departments, Employees, Products etc. 
2. Don't migrate historical transactions and start with new records: Sales Orders, Tasks, Invoices. 

In most of the cases historical data is needed for analytic purposes only, so you can do that in old software / external BI tools 

On Wed, Feb 25, 2015 at 8:08 PM, André P. <app@thinkopensolutions.pt> wrote:
We use Pentaho Kettle to make those kinds of conversions. But prepare for a few weeks of work, and to study the data models of both systems in detail - it's not an easy task, especially if there are many tables.

2015-02-25 16:43 GMT+00:00 cyr saint <saintcyrwin@gmail.com>:
Hi, i'm in Odoo 8.0. I want to use my dolibarr database in Odoo 8.0. I have backup my dolibarr database in a dump sql format. How can i do this import(or conversion) please?

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe




--
Cumprimentos,


André Paramés

Developer

Miraflores Office Center,

Avenida das Túlipas, nº 6,

13ºA/B 1495-161 Algés

e. app@thinkopensolutions.pt

m. +351 960 029 663

t. +351 214 123 492

f. +351 214 123 493

O conteúdo desta mensagem de correio electrónico e seus anexos é confidencial e de uso reservado. Se não é o destinatário apague-a e informe o remetente. Esta mensagem é verificada pelo nosso sistema de anti-vírus, ainda assim não aceitamos qualquer responsabilidade por danos causados por vírus que possam estar contidos nesta mensagem. Para mais informações visite-nos em www.thinkopensolutions.com.

 Não imprima este email caso não seja estritamente necessário. A Terra agradece-lhe!

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe




--

Best Regards,
Roman Gurinovich

Director, XPANSA Group | ERP, BI, E-commerce, Data Mining and DMS consulting
Xpansa CLOUD | Full Business IT Infrastructure | https://xpansa.com/products/xpansa-odoo-alfresco-bi-saas/
mERP | Odoo Android App | merpapp.com

/// site  : xpansa.com
/// mail  : roman.gurinovich@xpansa.com
/// phone, EE : +3726094038
/// phone, BY : +375295736353
/// skype : roman.gurinovich

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe