8 results found
-
Update flyway.batch to include CREATE files
For flyway.batch can create files be included in batching of files together. This could allow for large set of create statements to be batch together for things when there are hundreds of migrations that can be rolled out faster.
3 votesHi.
I'm not sure if I fully understand the suggestion. You can put multiple CREATE statements in the same V script. In Flyway Enterprise, we can do this for you in SQL Server, Oracle, Postgres, and MySQL; and we work out the dependencies for you.
Another thing might be to consider re-baselining, if you have a lot of V scripts and need to get them all in 1 B script - https://documentation.red-gate.com/fd/rebaselining-208896090.html.
If you'd like to talk more about this so I can better understand this suggestion, please schedule a 15 min zoom with me at https://calendly.com/stephanie-herr/15min-1?month=2023-11.
Thank you!
Stephanie Herr :-)
Product Manager, Database DevOps
-
Add the ability to use MSA accounts
The JDBC only makes provision to connect to database setting integrated security to true or false, when false we need to provide a username and password, which we do by using the library. But this is a SQL User and we want to use an MSA account for Audit purposes. Microsoft Service Accounts don't require a password to be set as it is passed from one server to the next when the connection between any 2 or more previously set up servers has been configured to use MSA. We need a way for flyway to authenticate by making use of…
1 vote -
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 an option to ignore the state of triggers during comparison
We have an application that likes to disable and enable triggers during loads so these get in different stages depending on the state of our database. It would be nice to ignore these and not see them as differences when looking or comparing them in Flyway Desktop. We can't exclude them in our database as they are triggers that we need but we really don't need to compare them to source control since we know that one is enabled and the other is disabled its ok for us as the application turns these on and off as necessary.
1 vote -
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.
2 votesThe ability to configure the Comparison Options and Filters through the Flyway Desktop GUI is planned for Q2/Q3 2023. If you need any help with this beforehand, please review our docs (https://documentation.red-gate.com/fd/configuring-comparisons-and-script-generations-152109245.html) and, if needed, contact support@red-gate.com.
Thank you!
-
Install/Update without elevated user privileges
Security is more important then ever and company networks restrict permissions of Windows users.
Change Installer of Flyway Desktop to not needing elevated privileges (admin account) anymore.
Updating it should be easier.
4 votesDoes installing in a different location help?
-
Improve Development Database Connection Wizard
The "Link to a development database" wizard could be made more user friendly by moving less commonly-used options behind an expandable "Advanced Options" tab and providing auto-complete for database names once the server is known.
Specifically, the Port, Encrypt, Trust Server Certificate, and JDBC URL fields could be hidden behind an expandable Advanced Options tab because they are less likely to be used or changed. Port, Encrypt and Trust Server Certificate should retain the last used values as they are likely to be consistent within any given organization.
The Host and Instance fields could also be combined into a single…
2 votesThanks for your feedback. We have started on some designs to improve the layout of this dialog. We may have to move the auto-complete for database names into a separate suggestion, which I'll do when I update this.
-
Extend code analysis by adding SQL Prompt ruleset
SQLprompt has a bunch of rules in there, I'd love to see the performance rules available in Flyway
1 voteWith Flyway Enterprise, you can create your own custom rules using RegEx. I'm not sure if any of the SQL Prompt rules (especially the performance ones) can be re-written as RegEx because we haven't looked into this yet. I wanted to make sure you knew about our custom rules in case this is possible or you want to add additional rules.
Learn more at https://documentation.red-gate.com/fd/creating-regular-expression-rules-186679456.html.
- Don't see your idea?