Zum Inhalt springen
Odoo Menü
  • Anmelden
  • Jetzt gratis testen
  • Apps
    Finanzen
    • Buchhaltung
    • Rechnungsstellung
    • Spesenabrechnung
    • Tabellenkalkulation (BI)
    • Dokumente
    • E-Signatur
    Vertrieb
    • CRM
    • Vertrieb
    • Kassensystem – Shop
    • Kassensystem – Restaurant
    • Abonnements
    • Vermietung
    Websites
    • Website-Builder
    • E-Commerce
    • Blog
    • Forum
    • Livechat
    • E-Learning
    Lieferkette
    • Lager
    • Fertigung
    • PLM
    • Einkauf
    • Wartung
    • Qualität
    Personalwesen
    • Mitarbeiter
    • Personalbeschaffung
    • Abwesenheiten
    • Mitarbeiterbeurteilung
    • Personalempfehlungen
    • Fuhrpark
    Marketing
    • Social Marketing
    • E-Mail-Marketing
    • SMS-Marketing
    • Veranstaltungen
    • Marketing-Automatisierung
    • Umfragen
    Dienstleistungen
    • Projekte
    • Zeiterfassung
    • Außendienst
    • Kundendienst
    • Planung
    • Termine
    Produktivität
    • Dialog
    • Genehmigungen
    • IoT
    • VoIP
    • Wissensdatenbank
    • WhatsApp
    Apps von Drittanbietern Odoo Studio Odoo Cloud-Plattform
  • Branchen
    Einzelhandel
    • Buchladen
    • Kleidergeschäft
    • Möbelhaus
    • Lebensmittelgeschäft
    • Baumarkt
    • Spielwarengeschäft
    Essen & Gastgewerbe
    • Bar und Kneipe
    • Restaurant
    • Fast Food
    • Gästehaus
    • Getränkehändler
    • Hotel
    Immobilien
    • Immobilienagentur
    • Architekturbüro
    • Baugewerbe
    • Immobilienverwaltung
    • Gartenarbeit
    • Eigentümervereinigung
    Beratung
    • Buchhaltungsfirma
    • Odoo-Partner
    • Marketingagentur
    • Anwaltskanzlei
    • Talentakquise
    • Prüfung & Zertifizierung
    Fertigung
    • Textil
    • Metall
    • Möbel
    • Speisen
    • Brauerei
    • Firmengeschenke
    Gesundheit & Fitness
    • Sportklub
    • Brillengeschäft
    • Fitnessstudio
    • Therapeut
    • Apotheke
    • Friseursalon
    Handel
    • Handyman
    • IT-Hardware & -Support
    • Solarenergiesysteme
    • Schuster
    • Reinigungsdienstleistungen
    • HLK-Dienstleistungen
    Sonstiges
    • Gemeinnützige Organisation
    • Umweltschutzagentur
    • Plakatwandvermietung
    • Fotostudio
    • Fahrrad-Leasing
    • Software-Händler
    Alle Branchen ansehen
  • Community
    Lernen
    • Tutorials
    • Dokumentation
    • Zertifizierungen
    • Schulung
    • Blog
    • Podcast
    Bildung fördern
    • Bildungsprogramm
    • Scale-Up! Planspiel
    • Odoo besuchen
    Software anfragen
    • Herunterladen
    • Editionen vergleichen
    • Releases
    Zusammenarbeiten
    • Github
    • Forum
    • Veranstaltungen
    • Übersetzungen
    • Partner werden
    • Dienstleistungen für Partner
    • Buchhaltungsfirma registrieren
    Services anfragen
    • Partner finden
    • Buchhalter finden
    • Einen Experten treffen
    • Implementierungsservices
    • Kundenreferenzen
    • Support
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Eine Demo erhalten
  • Preiskalkulation
  • Hilfe

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

  • CRM
  • e-Commerce
  • Buchhaltung
  • Lager
  • PoS
  • Projekte
  • MRP
All apps
Sie müssen registriert sein, um mit der Community zu interagieren.
Alle Beiträge Personen Abzeichen
Stichwörter (Alle anzeigen)
odoo accounting v14 pos v15
Über dieses Forum
Sie müssen registriert sein, um mit der Community zu interagieren.
Alle Beiträge Personen Abzeichen
Stichwörter (Alle anzeigen)
odoo accounting v14 pos v15
Über dieses Forum
Hilfe

Discussion on Data Migration Methods

Abonnieren

Erhalten Sie eine Benachrichtigung, wenn es eine Aktivität zu diesem Beitrag gibt

Diese Frage wurde gekennzeichnet
migrationdatamigrationv15v18
2 Antworten
537 Ansichten
Avatar
RGonzalez

Hello everyone, I hope you're all doing well.


I have an interesting requirement to discuss. I'm trying to migrate data from V15 to V18. The main problem is that the company that sold us V15 no longer exists, so I don't have the updated code for V18, which prevents me from using the Odoo.sh update process.


With this in mind, I only have the following options left: 

1. Pay for a perpetual V15 subscription for local or web use, maintaining data persistence.

2. Perform a schema-to-schema mapping to migrate all the information.

3. Manually upload all the data to the system using CSV and UI, setting computed data as editable to facilitate the loading of auto-generated data (sequences, amounts, etc.).


Each option has its advantages and disadvantages, both objectively and subjectively. 


1. Subscription Payment.

The company doesn't want to pay an extra membership fee just to maintain persistence. I tried a local installation, but the community version is obviously not compatible with our enterprise version, and this version requires a license. 


2. Schema-to-Schema Mapping.

This is a considerably lengthy and extremely methodical task, especially if data integrity is to be maintained. For our database, this would involve validating a total of 200 tables for mapping, with any number of columns. After this, migration scripts would need to be created for each model, although this is easier with AI. 


3. Manual Loading.

This, like the previous option, is considerably lengthy, but more mechanical than methodical. It would involve a total of two years' worth of data, and would only require manually setting up financial and inventory transaction data, since data such as customers, products, opportunities, quotes, and tickets can be easily handled via a script. In total, this would involve approximately 3,000 accounting entries. The good thing is that we could use an RPA to handle the setup record by record. The complexity lies in the computerized data; doing things manually could cause problems if the procedure isn't followed in the order it was executed. A practical example of this would be inventory operations, where the receipt date field is automatically assigned the current date. 

I've been thinking a lot about which of the last two options would be the most practical for a migration with a 3- to 4-month timeframe, and I'd love to have more perspectives to determine an option, or a new alternative.


Thank you in advance. Have a great weekend.

0
Avatar
Verwerfen
Creyox Technologies

Hello,

Do you have access to your current Odoo.sh instance? How much customization have you implemented in v15?

Let us know, and we'll do our best to help you migrate to v18 with your existing data, without any unnecessary steps.

Thanks,
info@creyox.com

RGonzalez
Autor

Hello, I hope you are well.


Thank you very much for your prompt response.


We have several customizations, practically the entire localization; however, we have developed our own localization and what we want is to migrate from one version to another using this new data schema as our target.

Avatar
Cybrosys Techno Solutions Pvt.Ltd
Beste Antwort

Hi,


Migrating from Odoo 15 Enterprise to Odoo 18 without access to the original vendor’s code or Odoo.sh repository is indeed complex, especially since the enterprise version requires a valid license and code compatibility. Of the three options you’ve outlined, each has trade-offs depending on your priorities, cost, accuracy, and time.


Maintaining a perpetual subscription is the easiest way to preserve data integrity and ensure legal access to the codebase, but if the company refuses to pay, it’s not a viable path. The schema-to-schema migration (option 2) is the most technically accurate approach since it preserves relationships and dependencies across tables, but it demands deep database knowledge and time to validate all models. It’s best suited if data consistency and accounting traceability are top priorities.


The manual loading option (option 3) is more practical if you can tolerate some data loss in non-critical areas and rely mainly on high-level historical data (e.g., balances, inventory valuations, or sales summaries). Using RPA scripts or import templates could make this feasible within your 3–4 month timeframe, though care is needed with computed fields and transaction order.


In short, if your goal is accuracy and continuity, go with schema mapping and scripts; if you prioritize speed and simplicity, opt for manual imports with automation support. A hybrid approach, automating imports for master data and scripting key financial and stock movements,often offers the best balance for migrations like this.


Hope it helps

0
Avatar
Verwerfen
Avatar
Ray Carnes (ray)
Beste Antwort

You have several options:

1 - IDEAL / NO WORK AT ALL

It may be possible to keep a single read only license to your old system

  • Pros - easy to look things up, nothing new to learn
  • Cons - it is another system, so now things are in two places

2 - QUICKEST / EASIEST

Import Excel sheets of the relevant information into Odoo Spreadsheets via the Documents App

  • Pros - get access to what you need without much work to import
  • Cons - harder to search for things, not integrated well

3 - MORE WORK

Create a Studio App and import tables of CSV data

  • Pros - can use Odoo filtering and search, form and list and kanban views, can link to Customers via Smart buttons
  • Cons - takes more time

4 - EVEN MORE WORK

Import Monthly Trial Balances

  • Pros - you can run year on year comparisons
  • Cons - takes even more time

5 - THE MOST WORK

Import Transactions

  • Pros - works as if you were using Odoo the whole time
  • Cons - VERY VERY VERY time consuming, needs scripts, very advanced knowledge required, may not have a good return on investment 
0
Avatar
Verwerfen
RGonzalez
Autor

Hello, I hope you are well.

Thank you very much for your quick response.

I hadn't considered the idea of ​​having a single-user license, and it's not expensive at all, around $160 per year with all the applications.

Now, I'm wondering where to get the Enterprise version code to perform a local installation, because I've searched the official Odoo website, and it only shows up to version 16, and the GitHub link for Enterprise isn't working. And since the Community version doesn't have the Studio app, it will conflict with my database dump.

I was told this weekend that there's a page for Odoo partners where you can access the Enterprise version code.

I appreciate your previous help, and if you could help me with this last question, I would be very grateful.

Ray Carnes (ray)

Anyone with a valid subscription can download Odoo Enterprise from odoo.com/download

Diskutieren Sie gerne? Treten Sie bei, statt nur zu lesen!

Erstellen Sie heute ein Konto, um exklusive Funktionen zu nutzen und mit unserer tollen Community zu interagieren!

Registrieren
Verknüpfte Beiträge Antworten Ansichten Aktivität
Odoo Community 15 to 17 migration procedure ? Gelöst
migration v15 v17
Avatar
Avatar
Avatar
Avatar
Avatar
5
Juni 25
19086
How to migrate Odoo 14 DB to Odoo 15 DB Gelöst
migration odoo v15
Avatar
Avatar
1
Jan. 23
14153
Module migratior error Gelöst
migration v14 v15
Avatar
Avatar
Avatar
3
Sept. 22
4885
How to migrate custom addons from odoo12 to odoo15 from odoo.sh with existing data?
migration odoo12 v15
Avatar
0
Juli 22
3119
Migration from bitrix24 CRM to Odoo
crm migration v15
Avatar
Avatar
Avatar
2
Nov. 23
5265
Community
  • Tutorials
  • Dokumentation
  • Forum
Open Source
  • Herunterladen
  • Github
  • Runbot
  • Übersetzungen
Dienstleistungen
  • Odoo.sh-Hosting
  • Support
  • Upgrade
  • Individuelle Entwicklungen
  • Bildung
  • Buchhalter finden
  • Partner finden
  • Partner werden
Über uns
  • Unsere Firma
  • Markenwerte
  • Kontakt
  • Karriere
  • Veranstaltungen
  • Podcast
  • Blog
  • Kunden
  • Rechtliches • Datenschutz
  • Sicherheit
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk slovenščina Español (América Latina) Español ภาษาไทย Türkçe українська Tiếng Việt

Odoo ist eine Suite von Open-Source-Betriebsanwendungen, die alle Bedürfnisse Ihres Unternehmens abdecken: CRM, E-Commerce, Buchhaltung, Lager, Kassensystem, Projektmanagement etc.

Das einzigartige Wertversprechen von Odoo ist, dass es gleichzeitig sehr einfach zu bedienen und voll integriert ist.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now