zhongjiajie opened a new issue, #11286: URL: https://github.com/apache/dolphinscheduler/issues/11286
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/dolphinscheduler/issues?q=is%3Aissue) and found no similar feature requirement. ### Description currently we using bare sql script to init or upgrade our databases which we can see in https://github.com/apache/dolphinscheduler/tree/dev/dolphinscheduler-dao/src/main/resources/sql/upgrade and it is face some issue * have to write multiple database type and multiple place * multiple database type: to adopt different database: currently we support postgres, mysql, h2 * multiple place: we have to change multiple sql script files when we need to upgrade it, and have consistency issues * do not support downgrade: if user just want to test the latest versions, we should better have downgrade command * can not rerun: for ddl we can use store process to fix it(complex), but dml like insert may have error(duplicate key), or insert some record without uk. ### Use case _No response_ ### Related issues _No response_ ### Are you willing to submit a PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
