Best Practices for Migrating Databases to a New Senaite Instance

Technical
1

Hello Senaite Community,

I am looking for a comprehensive guide or best practices on migrating databases from an older Senaite instance to a fresh installation. If there are any official tutorials, documentation, or community-shared experiences on handling data migration efficiently, I would greatly appreciate any insights.

Looking forward to your guidance!

Best regards,
haideralwaqfi@gmail.com
WhatsApp: 00962799170349

2

Hi @haideralwaqfi

We provide upgrade steps in each major SENAITE release that updates from the previous version to the one used.

Therefore, if your SENAITE site is running on 2.1.0, you need to first update your codebase to 2.2.0, run all the upgrade steps and continue with 2.3.0, 2.4.0, 2.5.0 and soon 2.6.0.

However, if you are still on 1.3.x, things might get a bit tricky.
I would then only update to 1.3.5 and then try to directly update to 2.0.0.

Please don’t forget to make backups of your filestorage/blostorage folders before.

Hope that helps

1 Like
3

Dear @ramonski ,

Thank you for your response.

I need to migrate a database to a new Senaite instance on a different server. Please let me know the best approach for this.

Best regards,
Haider

4

Dear @ramonski,

After conducting multiple experiments on my local machine, I have concluded that I can successfully migrate data by copying only the filestorage folder to the var directory, followed by restarting the instance. This approach ensures that all information is transferred, except for source code modifications from the old instance. These modifications need to be manually migrated to the new instance as well.

Best regards,
Haider Al Waqfi
haideralwaqfi@gmail.com

5

Thanks for your feedback @haideralwaqfi,

I’m glad to hear that it works without further issues.
Just remember to run eventual Upgrade Steps from the Add-Ons control panel, in case that the codebase is newer than the one you had on the previous system.