Activity overview
Latest activity by mattlavallee
It's worth mentioning that I say all this because the irony is that the Interactive HTML Report *does* do exactly what I expect. [image] That is, it includes only the affected-column changes.
-Matt / comments
It's worth mentioning that I say all this because the irony is that the Interactive HTML Report *does* do exactly what I expect. That is, it includes only the affected-column changes.
-Matt
Okay, maybe I'm just having a usability issue, then... I think I've figured out what's going wrong (for me), but I'm not sure there's a better approach. Just for validation, here are my steps:
Set the two data sources, and direction from Dev to Prod.
Hit Actions -> Exclude All.
Select the three table changes and one added scalar-value function from the list.
Go to Synchronization Wizard... (this is where I may be going wrong, but I can't find another way to get the change script)
Here, it is including *all* of the index and constraint differences between the tables, not just those affecting the changed columns. Of course, I don't want to drop all of my destination indexes and recreate them, particularly since none affect the column I'm concerned with moving... and I can't turn off the constraint or index options because then the changes I want to propagate wouldn't include these dependencies.
Does that make sense? Is there any way to be more granular about what gets moved at the table level, i.e., to consider the column-level differences?
Also, is there another way of getting the change script rather than going into the Wizard and viewing the source? That feels awkward, because I don't actually want to apply the change yet, we just want the SQL.
Thanks for your help,
-Matt / comments
Okay, maybe I'm just having a usability issue, then... I think I've figured out what's going wrong (for me), but I'm not sure there's a better approach. Just for validation, here are my steps:
Set...
Filtered change script?
Hi,
I'm trying to generate a change script (between Dev and Prod live databases) to include only column changes between 3 tables. In other words, only creating statements like:
ALTER TABLE x ADD C...