As I learned in this thread http://www.red-gate.com/MessageBoard/vi ... hp?t=15518 SQL Compare will always show me all differences on a objects if it found one difference which I didn't want to ignore during the comparison.
Now, I want to deploy only these changes from a object which aren't ignored by the comparison that I have ticked at the options of SQL Compare (e.g. ignore constraint names is enabled). I give you one example.
I ticked the option to ignore data compression on the comparison between two different database. Now, I have table with activated data compression on the source database, but not on the target database. On this table I have a new column on the source database, but not on the target database.
SQL Compare should now create me a deployment script with the new column, but without the data compression option, because I ticked the option "ignore data compression" at the SQL Compare option.
Is there any way how I could do it? SQL Compare should show me the table with all difference, but create me a deployment script only with the new column, because I enabled the option "ignore data compression".
Do you get the purpose of my question?