Column-level control over comparison SQL

[piers7]

Is there any way via the API of controlling the generated schema comparison script (from SQL Compare) at a column level?

What I want to do is exclude certain columns from being syncronised, or adjust how they are sync'd. Specifically for columns that we are going to drop in production, I would prefer to rename them to xxx_Deleted (or something) rather than actually drop them. This gives me a simpler rollback if it turns out that the column should not have been dropped, and it was just that a column rename wasn't picked up on properly.

I was hoping to open the Work object generated from the Differences, and disable / modify sync actions on a column by column basis, but it looks like it's all been rendered down into SQL by that stage, which makes this a bit tricky (ie if the table is being rebuilt, it's very hard to detect that the column is being effectively dropped)

Cheers,

[Tom Harris]

I'm afraid that this level of control is not available via the API. We may add it in the future if there is sufficient demand.

Apologies, Tom

[cleek]

Having the ability to control the schema comparison script at a column level is something that we would really like to have. Please consider this a feature request.

[cleek]

What I really need is the ability to ensure that no column in the target database is dropped.

[Brian Donahue]

I have written some sample code for the SDK wiki that will comment out all column drops from the SQL Compare SQL scripts. I hope you all find this useful!!

http://78.31.104.66/index.php/Filter_migration_script
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521