Can I Exclude Certain Columns From The Update Script
Matt Connors
Posts: 6
I created a project and ran a comparison. I then filtered out all objects except tables. I can now choose which tables get included in the deployment script.
What I need to do is select specific changes to the table. In other words I need some, but not all, of the table changes. For instance I need to migrate the changes to only 2 of 4 columns that have changed.
The only way I can think how to do this is to generate a script for the table and then go through and manually change that script to remove those changes I do not want.
Is there an easier way to do this? Does SQL Compare support selecting changes at the column level?
Thanks in advance,
Matt
What I need to do is select specific changes to the table. In other words I need some, but not all, of the table changes. For instance I need to migrate the changes to only 2 of 4 columns that have changed.
The only way I can think how to do this is to generate a script for the table and then go through and manually change that script to remove those changes I do not want.
Is there an easier way to do this? Does SQL Compare support selecting changes at the column level?
Thanks in advance,
Matt
Comments
SQL Compare doesn't let you exclude individual columns from a schema comparison. The feature request to impelement this is SC-4227. You may be best off exclusing the table entirely from the comparison and scripting the changes you want to make manually.