Activity overview
Latest activity by rb13c
Thanks! I got this to work now using that. Previously I actually was using /scripts1 rather than /sourcecontrol1 and /sfx. / comments
Thanks! I got this to work now using that. Previously I actually was using /scripts1 rather than /sourcecontrol1 and /sfx.
How to ONLY compare static data tables?
We're using SQL Source Control to link static data for a subset of tables in our database. Using the command line I can successfully run a SQL Data Compare from source control to a database. Howeve...
Thanks, I'll add something to the feature request page. My intentions aside, I'm still unclear how the /include:StaticData actually works. Is it dependent on other /include switches?
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? / comments
Thanks, I'll add something to the feature request page. My intentions aside, I'm still unclear how the /include:StaticData actually works. Is it dependent on other /include switches?
For example fo...
Thanks for the insight. So there is no way to deploy static data through the SQL Compare GUI then?
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. / comments
Thanks for the insight. So there is no way to deploy static data through the SQL Compare GUI then?
Also, I think it would be useful to change this from an all or nothing use. For example I have dat...
How to get /include:StaticData functionality with /Filter?
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 ...