Can I Exclude Certain Columns From The Update Script

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

Can I Exclude Certain Columns From The Update Script

Postby Matt Connors » Thu Mar 07, 2013 4:22 pm

I created a project and ran a comparison. I then filtered out all objects except tables. I can now choose which tables get included in the deployment script.

What I need to do is select specific changes to the table. In other words I need some, but not all, of the table changes. For instance I need to migrate the changes to only 2 of 4 columns that have changed.

The only way I can think how to do this is to generate a script for the table and then go through and manually change that script to remove those changes I do not want.

Is there an easier way to do this? Does SQL Compare support selecting changes at the column level?

Thanks in advance,
Matt Connors
Posts: 4
Joined: Wed Feb 27, 2013 7:40 pm

Postby Brian Donahue » Mon Mar 11, 2013 5:39 pm


SQL Compare doesn't let you exclude individual columns from a schema comparison. The feature request to impelement this is SC-4227. You may be best off exclusing the table entirely from the comparison and scripting the changes you want to make manually.
Brian Donahue
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 1 guest