Columns excluded for compare are not included as part of the deployment script

JayVEE

Hi Redgate,

I'm running SQL Data Compare 13.x.

I have a database from two different deploy versions of our software (13 and 14) and I want to create a deploy script allowing me to run it on the older version to upgrade it to the current version.

The tables have 4 audit fields, so I have excluded these from the comparison so I can get a truer picture of the data that has changed.

When I run the comparison I can clearly see what has changed, so far so good. Next I hit the "Deploy" button and create a deployment script.

This is where the problem starts, on inspecting the script I can see that the inserts are excluding the columns that have been excluded from the comparison. But this is not what I want, there has been an assumption somewhere that just because I don't want to compare the columns that I don't want to script them, but this isn't the case.

I have looked in the options and don't see a way to change this behavior.

Can you help please ?

Thanks
Jon

Tianjiao_Li

Hi @JayVEE

I'm afraid this is not possible at the moment. We already got this feature request on our user voice forum which has proven to be popular. Can you kindly cast your vote on it as well? It helps the product team to justify this feature. https://redgate.uservoice.com/forums/147879-sql-data-compare/suggestions/18273358-excluding-columns-from-data-comprison-with-options