使用Flyway迁移存储过程 [英] Migrating Stored Procedures with Flyway

问题描述

如何使用数据库迁移工具（如Flyway）来管理像存储过程的过程数据库代码？

How should procedural database code like stored procedures be managed with a database migration tool like Flyway?

与DDL不同，我不想看到对存储在多个数据库迁移文件中的存储过程的更改。如何在单个文件中在源代码控制下管理过程代码，而且还可以利用具有Flyway等工具的数据库迁移功能。

Unlike DDL I would not want to see changes to a stored procedure stored within multiple database migration files. How can procedural code be managed within a single file under source control, but also take advantage of database migrations with a tool like Flyway?

推荐答案

p>在框架中没有特殊的结构来处理这个。

There is no special construct in the framework to deal with this. Mainly because I haven't figured out a way to do this that pleases me.

更新：重复脚本现在完全支持，因为Flyway 4.0。请参见 https://flywaydb.org/documentation/migration/repeatable

Update: Repeatable scripts are now fully supported as of Flyway 4.0. See https://flywaydb.org/documentation/migration/repeatable

这篇关于使用Flyway迁移存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！