No option to exclude dependencies from schema model update
a.higgins
Posts: 90 Bronze 2
When I go to commit a change using Flyway Desktop, the "schema update" will almost always include extra artifacts that I did not choose.
These are listed as dependencies, but due to my data model (many foreign keys) and a generous definition of "dependencies" (e.g., a stored procedure references a table, and another stored procedure references a table with a foreign key relationship to the first table, which apparently means both objects are going to be committed), I almost never actually want to commit these objects together.
I can work around by only choosing some items in the "commit changes" window, but then I have a whole pile of other things sitting there waiting to be committed, and it's a huge pain. My team's workflow is to hop back and forth between Visual Studio and Flyway, undoing and removing unwanted items before committing.
Is there a way to "ignore dependencies" when saving changes to my schema model?
These are listed as dependencies, but due to my data model (many foreign keys) and a generous definition of "dependencies" (e.g., a stored procedure references a table, and another stored procedure references a table with a foreign key relationship to the first table, which apparently means both objects are going to be committed), I almost never actually want to commit these objects together.
I can work around by only choosing some items in the "commit changes" window, but then I have a whole pile of other things sitting there waiting to be committed, and it's a huge pain. My team's workflow is to hop back and forth between Visual Studio and Flyway, undoing and removing unwanted items before committing.
Is there a way to "ignore dependencies" when saving changes to my schema model?
Tagged:
Answers
Yes there is!
As noted, the dependencies are included by default, this option is governed by the property 'IncludeDependencies' as detailed here.
https://documentation.red-gate.com/flyway/database-development-using-flyway-desktop/configuring-comparisons-and-script-generations/comparison-options/sql-server-comparison-options
In the Flyway GUI, if you navigate to 'Static data and comparisons', the option will look like this