Bring your towel and join one of the fastest growing data communities. Welcome to our second-generation open source orchestration platform, a completely rethought approach to dataflow automation.

Prefect Community

Does someone from the Prefect staff could provide some guidances to tackle these migration questions ?

It will be really appreciated if experts could give us insights and orientations to complete such migrations, thanks :pray:

hi <@U04UD2F1XJN> - database migrations are sort of their own thing. we have integration tests for all minor versions of prefect 2.x to make sure we don't introduce breaking API changes, so in terms of the SDK you should be free to upgrade, unless you depend on very early prefect 2.x behavior like certain `prefect deployment build` flags or `PREFECT_ORION` settings etc

feel free to raise what db migration issues you're having here!

We already tackle the conversion `PREFECT_ORION` -> `PREFECT_SERVER` and others settings, it was during the upgrade from [2.8.0](<https://github.com/PrefectHQ/prefect/blob/main/RELEASE-NOTES.md#release-280>) to [2.8.1](<https://github.com/PrefectHQ/prefect/blob/main/RELEASE-NOTES.md#deprecated>) as I recall.

From your experience, do we need to stage the upgrade versions by versions or we can directly upgrade from `2.9.0`  to `2.18.0` ? Thanks for your replies <@U02GMEZU18B> :wave:

As far as I know, as DB migrations are handled by `alembic` under-the-hood, I think it should be effortless and safe :pray: