in frappe can we restore database backup off v14 bench to v16 bench directly
Technically I would say yes. bench migrate runs all pending patches in order, so v15 and v16 patches will all get applied after the restore.
That said, I’d always recommend upgrading one major version at a time. Skipping versions increases the chance of a patch failing mid-way, and if you have custom apps or client/server scripts, the odds of something breaking are high.
Best bet: try it on a test site first before touching production.
Because v16 is expecting the v15 schema and behavior, while you’d be giving it v14 one. Update one major upgrade at a time to be safe.
I found this while browsing and wanted to add—has anyone tried this recently with v17? With every update, the migration process might have gotten smoother or trickier. If anyone has insights or new experiences, sharing them here could benefit others considering the upgrade path!