Column-level control over comparison SQL

Forum for users of SQL Toolkit 3,4,and 5

Column-level control over comparison SQL

Postby piers7 » Fri Dec 07, 2007 2:00 am

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)

Posts: 9
Joined: Thu Jul 12, 2007 7:35 am

Postby Tom Harris » Sat Dec 08, 2007 9:14 pm

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
Tom Harris
Posts: 308
Joined: Wed Oct 06, 2004 2:45 pm

desired feature

Postby cleek » Fri Jan 30, 2009 5:28 pm

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.
Posts: 3
Joined: Fri Jan 30, 2009 5:20 pm

do not actually need column level control

Postby cleek » Fri Feb 06, 2009 9:23 pm

What I really need is the ability to ensure that no column in the target database is dropped.
Posts: 3
Joined: Fri Jan 30, 2009 5:20 pm

Postby Brian Donahue » Fri Jul 10, 2009 4:40 pm

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!!
Brian Donahue
Posts: 6590
Joined: Mon Aug 23, 2004 9:48 am

Return to SQL Toolkit Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests