Siirry sisältöön
Sinun on rekisteröidyttävä, jotta voit olla vuorovaikutuksessa yhteisön kanssa.
Kaikki kirjoitukset Ihmiset Merkit
Tunnisteet (Näytä kaikki)
odoo accounting v14 pos v15
Tietoa tästä foorumista
Tämä kysymys on merkitty
datadatabasesporting
1 Vastaa
3452 Näkymät
Avatar
CAMILLA

Hello-

We're looking into replacing our e-comm platform (written in Java and uses SQL Server) and our ERP (written . C# and uses SQL Server). It was written 10 yrs ago and there are stored procs, triggers, customer data, views, customer data, etc to port to the new system.

I'm evaluating Odoo as a replacement. I installed Odoo community edition code and the database. 


Has anyone here worked on porting data from their old database to new one like Odoo?

I'm sure we need to identify , for example, which tables hold customer data and map the data from old system to new one. Adjust the stored procs to match the new database's schema.


Anyone has gone thru such a data porting task? Thanks for any input and advice




Avatar
Hylkää
CAMILLA
Tekijä

Thanks. Yes, it's going to be difficult because we're on SQL Server and Odoo is on Postgres. I know the syntax is different. Porting all this stored procs will be difficult. Thanks for your response. 

Avatar
Gustave
Paras vastaus

Hi, it may be difficult, you can use a portal tool like Talend, and split your data migration by functionnality, to test step by step.

Do you know if the native odoo code match with your need ? Maybe you will need first to create custom modules.

You can try to create a demo datas batch on your current ERP to start your migration job on a small ans simple database. 

Thats all i can tell.

Gus

Avatar
Hylkää
Aiheeseen liittyviä artikkeleita Vastaukset Näkymät Toimenpide
Exchange data between databases
data exchange databases
Avatar
Avatar
Avatar
2
maalisk. 15
6167
How do I delete a database?
databases
Avatar
Avatar
Avatar
3
syysk. 25
1868
Data for relations table Ratkaistu
data
Avatar
Avatar
1
huhtik. 24
3199
Retrieve Existing Data from other model and Print it into the list view Ratkaistu
data
Avatar
Avatar
1
elok. 22
3668
Modules icons are missing after restoring database to another server
databases
Avatar
Avatar
1
toukok. 22
5206