Red Gate forums :: View topic - Can I Exclude Certain Columns From The Update Script
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

Can I Exclude Certain Columns From The Update Script

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Matt Connors



Joined: 27 Feb 2013
Posts: 4

PostPosted: Thu Mar 07, 2013 4:22 pm    Post subject: Can I Exclude Certain Columns From The Update Script Reply with quote

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
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6667

PostPosted: Mon Mar 11, 2013 5:39 pm    Post subject: Reply with quote

Hello,

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group