Enable Dark Mode!
By: Jumana Jabin MP

How to Change the Odoo Database From One Hosting Solution to Another

Technical Odoo 16

Odoo Hosting is the practice of hosting and managing Odoo ERP (Enterprise Resource Planning) software on a server or cloud infrastructure provided by a third-party hosting service provider.
Depending on the edition you are using, there are different types of hosting.
Odoo Enterprise applications can be hosted on three different platforms: Odoo Online, Odoo.sh (dedicated cloud), or On-Premises using your own infrastructure.
Odoo Community is only supported in Odoo Online and On-Premises.
Online hosting is SaaS (Software as a Service). It allows you to access your Odoo database from the cloud, just connect to odoo.com with your credentials through a web browser, and you can access your database. With this type of hosting, you are not responsible for maintaining your database as everything is managed by Odoo.
Key features of online hosting-(Cloud, Internet connection required, No installation required, No server maintenance required, Includes migration to an updated version,
includes email server, 100% safe from hacking, standard Odoo (no modifications), only Odoo applications (no third party applications)). Only the Odoo Enterprise version is available for this type of hosting.
On-premise hosting is "local." In such use, you are responsible for everything related to the operation of the software.
You need to purchase network infrastructure, power, servers, operating systems, etc. You also need to maintain all the necessary infrastructure to keep it functional, secure, and up to date.
Local hosting gives you complete control and freedom over your setup. To achieve and maintain hosting quality, you need the best experience. You also need to maintain all the necessary infrastructure to keep it functional, secure, and up to date.
Local hosting gives you complete control and freedom over your setup. To achieve and maintain hosting quality, you need the best experience. Key features of on-premise hosting — ( local installation, customization options (on existing applications or creating new applications, possible installation of third-party applications, the technical knowledge required to ensure the scope of maintenance, backup and data security, including migration to updated versions, full control, full autonomy and full responsibility Odoo Enterprise and Odoo Community editions are available for this type of hosting.
Odoo.sh, We also offer PaaS (Platform as a Service), Odoo. sh, which is a mix between the above two types of hosting. It allows you to create a cloud database while having your own development applications or third-party applications installed. Odoo sh allows you to deploy your own cloud platform with a few clicks. It also comes with an email server.
Changing hosting solutions in Odoo involves migrating your Odoo instance from one hosting provider to another.

From on-premise to Odoo Online

* Create a duplicate of your existing database. In this duplicate, uninstall all non-standard applications that you will not need in the new hosting environment.

* Grab a "filestore dump", Use the database manager in Odoo to generate a "filestore dump" of your database. This dump contains all the necessary files and data required for the migration.

* Open a support ticket, (https://www.odoo.com/sl_SI/help) Create a support ticket with your new hosting provider. Attach the file store-dump to the ticket. If the file is too large to attach directly, use any file transfer service and include the link in the ticket.

* Provide subscription details and URL. Along with the statement, provide Odoo subscription details and the URL you want to use for your database on the new hosting (eg: demo-company.odoo.com).

* Database compatibility check, The hosting provider will check your database to ensure compatibility with their cloud environment.

* Cloud Migration: Once compatibility is verified, the hosting provider will upload your database to their cloud infrastructure.

* Once the migration is complete, your hosting provider will notify you of a successful transfer. In case of any technical issues during the process, you will be contacted for resolution.

From Odoo Online to on-premise

Check your Odoo version, Log in to your Odoo Online user portal

(https://accounts.odoo.com/my/databases/manage) to find out the version number of your database. Before proceeding with the migration, it is important to know your version of Odoo.

Upgrade your database (if required), If your database is running on a version other than the main Odoo version, you must upgrade it before hosting it on-premises. For example, if your database is running on Odoo 14.0 (which is not a major version), you need to upgrade it to Odoo 15.0 or 16.0. The upgrade process ensures compatibility and access to new features.

Backup your database: Once you have the correct version or complete the upgrade, it is essential to create a backup of your database. In your Odoo Online user portal, click the "Gear" icon next to the database name and then select "Download". This action creates a backup file containing all information about your database.

Check the Backup File Size, Don't worry if the download fails because the backup file is too big. In such cases, it is best to contact your hosting provider's support team. They will help you find a suitable backup download solution.

Prepare your local server, To host the database on-premises, you need a local server that meets the system requirements for your version of Odoo. Make sure the server has the necessary resources and configuration for a smooth migration.

Restore your database:  Once your local server is ready, use the Odoo database manager to restore your database from a backup. Database Manager is a tool that allows you to import and manage your Odoo databases. Upload the backup file you downloaded from your Odoo Online user portal and restore it on your local server.

Test your local database. After restoring the database, thoroughly test it to ensure that all data, modules, and configurations have been successfully migrated. Review important features and customizations to make sure they work as expected.

Update your DNS settings (if available). If you are using a custom domain for your Odoo instance, be sure to update your DNS settings to point to the IP address or domain name of your new local server. This step will ensure that users can access your Odoo instance using a familiar URL.

Complete the migration. Once you are satisfied that everything is working correctly on your local server, complete the migration by directing users to start using the new instance of Odoo on the local server.

With these steps, you can successfully change your Odoo database hosting solution from an online server to a local server. However, please note that local hosting requires server infrastructure maintenance, security measures, and regular backups.

From on-premise to Odoo.sh

Odoo database migration from on-premise to Odoo.sh involves transferring your existing database and application data from your local server to Odoo.sh cloud hosting platform. For that, first, you have to set up a platform on Odoo.sh, follow these steps:

* Go to Odoo.sh and click "Deploy Your Platform": Visit the Odoo.sh website and click "Deploy your platform" to start the process.

* Sign in with your Github account: If you have a Github account, sign in with your credentials. If you don't already have one, click the "Create Account" link to create a new GitHub account.

* Grant Odoo.sh the required accesses: Allow Odoo.sh the necessary permissions by clicking the "Authorize" button. Odoo.sh requires access to your Github login and email, the ability to create a new repository (if you're starting from scratch), read access to your existing repositories (if you're using an existing repository), and the ability to create a webhook to notify you of changes.

* Choose a starting point: Decide whether you want to start from scratch by creating a new repository or use an existing repository as a starting point.

* Select Repository: Select a name for your new repository or select an existing repository to use for your Odoo.sh platform.

* Select Odoo version: Select the version of Odoo you want to use. If you plan to import an existing database or application suite, make sure you select the appropriate version. If you're starting from scratch, use the latest version available.

* Enter your subscription code: Enter your subscription code, also known as your subscription referral, contract number, or activation code. This code should match your Enterprise subscription which includes Odoo.sh.

* Starting a Partner Trial: Partners can use their partnership codes to start a trial. If their clients start a project, they should have an Enterprise subscription with Odoo.sh and use its subscription code. Affiliates will receive a 50% commission from this subscription. To obtain a partnership code, contact your sales representative or account manager.

By following these steps, you can successfully set up your Odoo.sh platform, and select a suitable starting point, Odoo version, and subscription code, which will ensure a smooth deployment of your Odoo instance on the cloud hosting platform.

After successfully setting up the odoo sh, you can follow the steps

* Export data from the On-Premise Odoo database, Access your local Odoo instance as an administrator, and proceed to export all the data you need, including information about customers, products, sales orders, invoices, etc. Odoo offers built-in export functions for various models, making the process straightforward.

* Create a backup of the local database. Before proceeding with the migration, it is important to create a backup of the local Odoo database.

* Setting up a new database on Odoo.sh: Within your Odoo.sh account, create a new database with the desired name. As long as the files are in a supported version of Odoo, you can import them into the Odoo.sh project.

* In the Odoo.sh project, in the Backups tab of the production branch, import the backup you just downloaded. After importing the backup, you can access the file using the Connect button in the branch history.

* If you have any custom modules or customizations in your local Odoo instance, you will need to install and configure them in the Odoo.sh database as well. It is necessary to verify that these modules are compatible with the version of Odoo running on Odoo.sh.

* After importing the data, perform thorough testing on the Odoo.sh instance to ensure that all data and customizations work correctly.

From Odoo.sh to on-premises

* Evaluate your current Odoo.sh instance, including the modules, customizations, and data you have in the system.

* Acquire the necessary hardware and software infrastructure to host Odoo on-premises. This may include servers, databases, web servers, and any other required components.

* Install Odoo on the new infrastructure, either by using the official installation script provided by Odoo or manually setting it up.

* Export the data from your Odoo.sh instance. You can use Odoo's built-in data export tools or specific data migration modules, if available.

* Import the data into the new Odoo on-premises instance. Downloadable and restoreable backup names, ability to perform manual backups, and import databases.

* Odoo.sh backs up production data every day. It holds 7 days of backup, 4 weeks of backup and 3 months of backup. Each backup includes dump files, archive files (file links, binary fields), logs, and partitions.

* Temporary files and updates are not backed up. However, you can still restore backups of your production storage in a test branch or manually restore deleted files from your site production store.

* Identify and gather all the custom modules, addons, and configurations from your Odoo.sh instance.

* Install and configure the necessary modules in the on-premises setup.

* Test the functionality of the modules to ensure they work correctly in the new environment.

From Odoo Online to Odoo.sh

* Log in to your Odoo Online user portal and find the database version number.

* If Odoo major version is not running in your repository, you still cannot host it in Odoo.sh, you need to upgrade it to a new major version first.

* Download a backup of your database by clicking on the “Gear” icon next to your database name, then Download

* Import your database section of the Odoo.sh documentation.

* In the Odoo.sh project, in the Backups tab of the production branch, import the backup you just downloaded. After importing the backup, you can access the file using the Connect button in the branch history.

Switching hosting solutions in Odoo is a significant undertaking that requires careful planning, meticulous execution, and thorough testing. It involves migrating your entire Odoo instance, including the database, files, and configurations, from one hosting environment to another. While the process can be complex, it offers potential benefits such as improved performance, scalability, and reliability.

If you need any assistance in odoo, we are online, please chat with us.


Leave a comment




Cybrosys Technologies Pvt. Ltd.
Neospace, Kinfra Techno Park
Kakkancherry, Calicut
Kerala, India - 673635



Cybrosys Technologies Pvt. Ltd.
1st Floor, Thapasya Building,
Infopark, Kakkanad,
Kochi, India - 682030.



Cybrosys Techno Solutions
The Estate, 8th Floor,
Dickenson Road,
Bangalore, India - 560042

Send Us A Message