Community mailing list archives

community@mail.odoo.com

Re: Conversion from mysql to postgreSQL

by
Conzl OU
- 02/26/2015 00:55:28
Hello Cyr, 

actually that is based on common business processes. Identify tables / data classes that satisfy two criteria: 
1. Data is being used in other transactional records (countries, currencies, units of measure, products, customers/suppliers etc).
2. Data is not changed constantly or is not transaction record (for example, list of countries will not change daily most likely).

Then you will export that tables to separate csv files. Make initial configuration of your Odoo (install modules, configure them and access rights). Import csv files to in appropriate applications one by one, for example, list of customers through the Sales > Customers > Import. 

So Odoo need to be configured / customized initially and then migrate your data table by table. No magic, but such migration process helps to avoid data corruption 

On Wed, Feb 25, 2015 at 10:32 PM, cyr saint <saintcyrwin@gmail.com> wrote:

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

_______________________________________________
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