Red Gate forums :: View topic - How do you disable the Ignore server in synonym feature
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Source Control 3
SQL Source Control 3 forum

How do you disable the Ignore server in synonym feature

Search in SQL Source Control 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
sproatba



Joined: 27 Jan 2012
Posts: 10

PostPosted: Fri Jan 27, 2012 10:01 pm    Post subject: How do you disable the Ignore server in synonym feature Reply with quote

In sql compare you can uncheck the option and it will detect synonyms that differ only by the server or database. I don't see any way to disable that option in sql source control so when i change my synonym it isn't picking it up as a change so I can't check it in.
Back to top
View user's profile Send private message
csmith



Joined: 30 Jun 2011
Posts: 117
Location: Cambridge

PostPosted: Mon Jan 30, 2012 11:12 am    Post subject: Reply with quote

Hi

In the latest version of SQL Source Control there is no option to configure the comparisons performed by the product (unlike SQL Compare - as you mentioned).

However, we are currently working on adding a comparison options configuration file to SQL Source Control that will allow you to detect synonym changes (and change many of the other options available in SQL Compare).

We are hoping to release this in the next few weeks via our 'Check For Updates' mechanism. I will add a post to this thread when that build is available.

Best regards,
Chris
_________________
Chris Smith
Project Manager
Deployment Manager
Back to top
View user's profile Send private message
csmith



Joined: 30 Jun 2011
Posts: 117
Location: Cambridge

PostPosted: Tue Feb 21, 2012 3:40 pm    Post subject: Reply with quote

Hi

SQL Source Control v3.0.5.7 includes a mechanism to allow comparison options (such as detecting synonyms) to be configured.

To get this version, please run Check For Updates from the Help menu in SQL Source Control. This is a free upgrade for existing licensed v3 users and for users with a Support & Upgrades contract.

Comparison options can now be set via a configuration file in your database repository's Working Base folder. The following Knowledge Base support article describes how to configure this option:
KB201202000521 - Setting SQL Compare options within SQL Source Control

Our plan in the future is to provide an options dialog to allow users to configure the comparison options that are changed most often, but we believe this configuration file procedure should help users in the interim.

If you'd like to see an options dialog exposing these settings in SQL Source Control, please vote on the associated Idea on our UserVoice site. It'd be great if you could also leave a comment indicating which specific options you'd like to see in the dialog.

Best regards,
Chris
_________________
Chris Smith
Project Manager
Deployment Manager
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