3 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 votesIt's now possible to specify a WHERE clause for any static data table for SQL Server. You can do this in the Flyway Desktop GUI or your project's TOML file.
We are interested in hearing your feedback on this and if you need this for other database types. Thank you!
-
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 votesFor SQL Server databases, you can configure Filters in the Flyway Desktop GUI. Use "Configure comparison" on the Schema Model page to access this.
If you need to setup Filters for other databases, please comment below and review our docs (https://documentation.red-gate.com/fd/filter-formats-282626175.html) for how to setup filters using the project files. If you need help with this, please contact support@red-gate.com.
Thank you!
-
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.
- Don't see your idea?