GitHub user dosubot[bot] added a comment to the discussion: superset5 to superset6 migration
<!-- Answer --> The migration from Superset 5 to 6 uses standard Alembic database migrations. Here are the commands you need: **Core Migration Commands:** ```bash # 1. Backup your database first (critical!) pg_dump superset_db > superset_backup_$(date +%Y%m%d).sql # 2. Upgrade Superset package pip install apache-superset --upgrade # 3. Run database migrations superset db upgrade # 4. Initialize application metadata superset init ``` **All your data is preserved** by `superset db upgrade`, including users, roles, dashboards, charts, datasets, and database connections. The migrations also [automatically convert legacy chart types](https://github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/superset/migrations/versions/2025-01-08_09-34_d482d51c15ca_remove_legacy_plugins_5_0.py) (Area, Bar, Line, etc.) to their ECharts equivalents. **Key Breaking Changes to Review:** - [OpenID authentication (AUTH_OID) has been removed](https://github.com/apache/superset/pull/33055) - migrate to OAuth/LDAP before upgrading if you use this - [`CUSTOM_FONT_URLS` replaced by theme tokens](https://github.com/apache/superset/pull/36317) - use `THEME_DEFAULT["token"]["fontUrls"]` instead - [`APP_NAME` no longer controls frontend branding](https://github.com/apache/superset/pull/37370) - use `brandAppName` theme token - CSS changes due to [Ant Design 5 migration](https://github.com/apache/superset/discussions/37145) may break custom styling **Recommendations:** 1. **Test in staging first** - [users report 5-10% of dashboards may need manual fixes](https://github.com/apache/superset/discussions/37145) after migration 2. Review the full [UPDATING.md](https://github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/UPDATING.md) for all breaking changes 3. After migration, verify dashboards load correctly and check for duplicate label validation errors (stricter validation in v6) <!-- Dosu Comment Footer --> *To reply, just mention [@dosu](https://go.dosu.dev/dosubot).* --- <sup>How did I do? [Good](https://app.dosu.dev/response-feedback/e551a1f8-dffd-4c7b-95e7-95f1a845b5b1?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/e551a1f8-dffd-4c7b-95e7-95f1a845b5b1?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/e551a1f8-dffd-4c7b-95e7-95f1a845b5b1?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/e551a1f8-dffd-4c7b-95e7-95f1a845b5b1?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/e551a1f8-dffd-4c7b-95e7-95f1a845b5b1?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/e551a1f8-dffd-4c7b-95e7-95f1a845b5b1?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/e551a1f8-dffd-4c7b-95e7-95f1a845b5b1?feedback_type=other)</sup> [](https://app.dosu.dev/a28d3c7e-a9d3-459e-9fb6-3a6f9ff4f357/ask?utm_source=github) [](https://cursor.com/link/prompt?text=The%20migration%20from%20Superset%205%20to%206%20uses%20standard%20Alembic%20database%20migrations.%20Here%20are%20the%20commands%20you%20need%3A%0A%0A%2A%2ACore%20Migration%20Commands%3A%2A%2A%0A%60%60%60bash%0A%23%201.%20Backup%20your%20database%20first%20%28critical%21%29%0Apg_dump%20superset_db%20%3E%20superset_backup_%24%28date%20%2B%25Y%25m%25d%29.sql%0A%0A%23%202.%20Upgrade%20Superset%20package%0Apip%20install%20apache-superset%20--upgrade%0A%0A%23%203.%20Run%20database%20migrations%0Asuperset%20db%20upgrade%0A%0A%23%204.%20Initialize%20application%20metadata%0Asuperset%20init%0A%60%60%60%0A%0A%2A%2AAll%20your%20data%20is%20preserved%2A%2A%20by%20%60superset%20db%20upgrade%60%2C%20including%20users%2C%20roles%2C%20dashboards%2C%20charts%2C%20da tasets%2C%20and%20database%20connections.%20The%20migrations%20also%20%5Bautomatically%20convert%20legacy%20chart%20types%5D%28https%3A//github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/superset/migrations/versions/2025-01-08_09-34_d482d51c15ca_remove_legacy_plugins_5_0.py%29%20%28Area%2C%20Bar%2C%20Line%2C%20etc.%29%20to%20their%20ECharts%20equivalents.%0A%0A%2A%2AKey%20Breaking%20Changes%20to%20Review%3A%2A%2A%0A-%20%5BOpenID%20authentication%20%28AUTH_OID%29%20has%20been%20removed%5D%28https%3A//github.com/apache/superset/pull/33055%29%20-%20migrate%20to%20OAuth/LDAP%20before%20upgrading%20if%20you%20use%20this%0A-%20%5B%60CUSTOM_FONT_URLS%60%20replaced%20by%20theme%20tokens%5D%28https%3A//github.com/apache/superset/pull/36317%29%20-%20use%20%60THEME_DEFAULT%5B%22token%22%5D%5B%22fontUrls%22%5D%60%20instead%0A-%20%5B%60APP_NAME%60%20no%20longer%20controls%20frontend%20branding%5D%28https%3A//github.com/apache/superset/pull/37370%29%20-%20use%20%60brandAppN ame%60%20theme%20token%0A-%20CSS%20changes%20due%20to%20%5BAnt%20Design%205%20migration%5D%28https%3A//github.com/apache/superset/discussions/37145%29%20may%20break%20custom%20styling%0A%0A%2A%2ARecommendations%3A%2A%2A%0A1.%20%2A%2ATest%20in%20staging%20first%2A%2A%20-%20%5Busers%20report%205-10%25%20of%20dashboards%20may%20need%20manual%20fixes%5D%28https%3A//github.com/apache/superset/discussions/37145%29%20after%20migration%0A2.%20Review%20the%20full%20%5BUPDATING.md%5D%28https%3A//github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/UPDATING.md%29%20for%20all%20breaking%20changes%0A3.%20After%20migration%2C%20verify%20dashboards%20load%20correctly%20and%20check%20for%20duplicate%20label%20validation%20errors%20%28stricter%20validation%20in%20v6%29) [](https://go.dosu.dev/discord-bot) [](https://twitte r.com/intent/tweet?text=%40dosu_ai%20helped%20me%20solve%20this%20issue!&url=https%3A//github.com/apache/superset/discussions/38286) GitHub link: https://github.com/apache/superset/discussions/38286#discussioncomment-15943132 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
