Column-level control over comparison SQL
piers7
Posts: 15
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,
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,
Comments
Apologies, Tom
http://78.31.104.66/index.php/Filter_migration_script