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
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.