Schema name as subfolders
Our project has 40+ schemas. Some of the schemas have several hundred stored procedures, functions, and views. We would like the option for the schema name to be a subfolder under each object type instead of the schema being a prefix on the file name. This would make it easier for developers to find the script files on disk during development as there wouldn't be thousands of files in each object folder.
For example, instead of
"schema-model\Functions\dbo.myFunc1.sql"
the path would be
"schema-model\Functions\dbo\myFunc1.sql".
Duane B
shared this idea
We now have the full model by schema in Flyway Desktop. You can learn more and try the feature at https://documentation.red-gate.com/fd/preview-features-and-upcoming-changes-in-the-next-major-version-of-redgate-flyway-289046605.html. Does this help or would you still want this replicated in the project folder on disk? Thank you!
-
Duane B
commented
Seeing the objects grouped by schema in Flyway Desktop is nice, especially if we will be able to select all objects for a schema to deploy to dev database. However, our company standards have the schemas separated in the project folder on disk, so we'd still like to see that feature.