2 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!
- Don't see your idea?