11 results found
-
Limit Static Data by rows using a WHERE clause
I would like the ability to source control a subset of rows in a table.
We have a table with extra rows in DEVELOPMENT for dev purposes ONLY. I don't want to track these in version control or deploy these.
16 votesCurrently, this is not available in the Flyway Desktop GUI. Flyway Enterprise ships with our Data Comparison technology for SQL Server and Oracle, so this can be done and automated as part of a pipeline. We've documented this at https://documentation.red-gate.com/display/FD/Tutorial+-+Using+Redgate%27s+Data+Compare+to+limit+rows and would love to discuss this with you.
-
Flyway Project Dashboard
I have around 20 schemas that I need to check. So I propose a dashboard that we can use to setup the schemas and then initiate a compare for those that we want to check.
This is to replace the functionality of the Source Control for Oracle, that we lost with the Flyway desktop. Having to open each Flyway project separately takes a long time, only to find no changes to the schema.
The Source Control did this all at once when you opened it, it showed all the registered schemas in one big list. It would then go off…
1 vote -
Flyway Desktop - Configurable config file location
It would be nice to be able to store the configuration normally in flyway.user.toml in a standard location instead of within the project folder.
Since .user.toml files are ignored by git then they need to be backed up and restored when the project is cloned to another machine (or deleted and re-cloned).
Instead it would be better if user settings where stored somewhere like ~/.flyway (macOS) and $env:APPDATA (Windows) so they can be migrated between machines easier.
1 vote -
Checkboxes for selective actions on Migrations tab
Migrations through the Desktop UI would be better if there were checkboxes to either apply migrations up to a certain point or just choose which migrations to apply.
1 voteThis is on our longterm backlog. If we get more votes, we can re-prioritize. Currently, you need to add the CherryPick or Target parameter in the advanced options and then copy and paste the version number(s) from the table.
Thank you!
-
Add Option to Disable Automatic Comparison
Currently, every time you open a project it automatically does a comparison between the Development database and the schema model. It also does an automatic comparison when switching branches in the VCS window. I might not always want this as I may not be pointing to the database I want to compare and have to wait for this comparison to finish before changing.
Having an option to disable automatic comparisons and only perform them when clicking the Refresh button would solve this.
3 votes -
Shift-select group of objects
I would like to be able to use shift to select a group of consecutive objects in the list of objects on the Schema Model tab. If I want to use Apply to Database for just tables and user-defined-types, I current have to select each individually, or perform multiple searches on the object type in order to narrow the list and use the 'select all' check box.
1 vote -
Re-baseline without manual intervention
It would be an incredible relief if a re-baseline were possible without manual intervention.
The steps described in the documentation for performing a re-baseline should be carried out automatically by the tool.
Or flyway only continues from the latest baseline.4 votes -
Easy way to skip, cherry-pick or out-of-order migrations in flyway desktop needed
To increase user acceptance, it would be very useful if the following steps were possible in flyway Desktop Enterprise without having to set parameters manually:
1.) Skip migrations and mark as applied
2.) Carrying out cherry-picking migrations
3.) Execution of out-of-order migrationsThis could be done, for example, via a menu entry in the migration list.
2 votes -
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".3 votesWe 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!
-
Specify a subfolder when generating or adding migration scripts
After I generate (or manually add) a migration script, it's automatically added to the migrations folder in the project. I want to organize my migration scripts better. Maybe by sprint or release number. Let me create subfolders in the migrations folder when I generate (or manually add) a migration script and save the script in that subfolder. I know subfolders are automatically included in the flyway migrate command.
4 votesRight now, migration scripts will be placed in the default migrations folder. Use the blue folder icon in the top-right of Flyway Desktop to jump to your project on disk. You can then move the migration script into a sub-folder in the migrations directory.
If you move the migration script to a different folder (outside of the migrations directory), then you'll need to update your locations configuration to account for both folders.
We do plan to add this to the GUI, but don't have a timeframe yet.
-
Add Filters to Flyway Desktop GUI
Incorporate the ability to adjust Filters into the GUI so you don't have to manipulate the JSON file manually. This was an option in SQL Source Control. It just looks like it wasn't incorporated into Flyway yet.
8 votesThe ability to configure Filters through the Flyway Desktop GUI is on our backlog. If you need any help with this beforehand, please review our docs (https://documentation.red-gate.com/fd/filters-ignore-rules-138347100.html). Please add votes/comments here to help us prioritize this. If you have any additional questions or need help, please contact support@red-gate.com.
Thank you!
- Don't see your idea?