How to approach a version upgrade with a SQL to MongoDB data migration
“How do we migrate Nuxeo from a SQL database to MongoDB?” This question comes up a lot and while it’s a complex topic that depends very much on the project, I think it’s very useful to lay out a few things to consider and steps on how to approach this migration.
But before I begin…I must warn you:
⚠ This is a very complex subject, so the blog post is very long! Feel free to jump (scroll if the links don’t work 😃 ) directly to any of the following sections:
- Migration scope: what do I need to migrate and how?
- Different migration strategies depending on the downtime
- Should I handle the Nuxeo version upgrade at the same time as the data migration?
- More tips & tricks on a successful migration
While the migration procedure will depend on your project, my hope is that by the end of this blog post, you will have a better understanding of what questions you need to ask.