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,