Red Gate forums :: View topic - Ignore merge replication constraints?
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

Ignore merge replication constraints?

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



Joined: 11 Nov 2008
Posts: 32

PostPosted: Mon Feb 20, 2012 11:29 pm    Post subject: Ignore merge replication constraints? Reply with quote

I would like to selectively ignore check constraints on table columns when the constraint name matches a pattern. The particular pattern is a check constraint name like [repl_identity_range_*].

My need arises from comparisons between two different multi-server environments, each of which has merge replication streams among several databases. These replication streams are functionally equivalent, but were NOT created at the same time. Therefore, there is a slight difference in the system-generated name and in the system-generated replication identity range values.

I have examined the project options for possible settings that would work.
I do NOT want to ignore all check constraints.
I do NOT want to ignore both Check constraint and Index names. Ignoring only Check Constraint names would be great!

Any suggestions on how to accomplish this?

Are there plans to add Check Constraints and/or to the types of objects to which name filters can be applied? Any plans to separate out the "ignore name differences" to target index names and constraint names independently?
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 938
Location: Red Gate Software

PostPosted: Thu Feb 23, 2012 2:46 pm    Post subject: Reply with quote

Thank you for your post into the forum.

I have added the details of this forum post to an existing Feature Request, reference number SC-4443.

I have also reset the status of the Feature Request to be reviewed. Hopefully the requested feature may appear in a later version of SQL Compare.

Thank you for bringing this problem to our attention.

Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
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