How to get /include:StaticData functionality with /Filter?
rb13c
Posts: 7
Using the command line I have been able to successfully use /include:StaticData.
However, I would like to use the StaticData comparison when using /Filter instead; not to mention the documentation recommends to use filters instead. However, according to the documentation, you can not use /Include and /Filter together. How do I specify in a filter to include static data? There is no option in the Sql Compare GUI for this when setting up filters. Is there a way to include staticdata by modifying the .scpf file directly?
However, I would like to use the StaticData comparison when using /Filter instead; not to mention the documentation recommends to use filters instead. However, according to the documentation, you can not use /Include and /Filter together. How do I specify in a filter to include static data? There is no option in the Sql Compare GUI for this when setting up filters. Is there a way to include staticdata by modifying the .scpf file directly?
Comments
If you need more granular control over data deployments, you'd need to look at using SQL Data Compare instead which gives you a lot more control over the data operations.
Redgate Software
Also, I think it would be useful to change this from an all or nothing use. For example I have database that is source controlled in which we created filters by schema. This allows us to differentiate between tables that get replicated in (which we ignore for deployments) and actual tables that we modify and own. It is in these tables only we own that we'd like to source control with static data.
The staticdata feature on the compare command line was added so you can simply deploy source controlled data without having to call another process, but it's a somewhat "simple" feature.
You might want to suggest better control over data over on the Compare Uservoice page so we can see how popular it is?
Redgate Software
For example for me "/include:StaticData" scripts up static data as well as other table schema change.
If I run "/include:StaticData /exclude:Table" or "/include:StaticData /exclude:Role" nothing is scripted.
If I run "/include:StaticData /exclude:View" the data gets scripted as well as just about everything other than views.
Is there anyway to ONLY script out the static data (and maybe table schema since I could understand the dependency) in a comparison?
Redgate Software