Red Gate forums :: View topic - can't exclude identical objects?!
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't exclude identical objects?!

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



Joined: 17 Feb 2011
Posts: 36

PostPosted: Thu Feb 28, 2013 12:55 am    Post subject: can't exclude identical objects?! Reply with quote

Why does SQL Compare now include identical objects by default? I'm generating HTML reports that show the differences between Subversion and the production database, and since I upgraded to 10.3 they're showing all the identical objects which makes the reports take forever to load and take up tons of disk space.

I am using a filter but apparently I can't simply add /exclude:identical if I'm using a filter (which would be great). So I spent a couple hours converting all of our filter rules to a complex set of /include and /exclude rules. Now I have a command line which is 2800 characters long (basically unmaintainable) and the identical object still aren't being excluded. Not to mention that I can no longer share my filters between the command line and GUI tools.

Thinking I had some error due to the immense complexity of the command, I simplified my command to just /exclude:identical and /exclude:additional. And it's still showing the identical objects. There seems to be no way to exclude them.

This change is a huge problem for us and I don't have time to try to develop a workaround, can you please revert back to the previous behavior?

And in the meantime, please provide me with a link to the version with the old behavior (10.1?) so I can install that. Thanks.


EDIT: It seems that the IgnoreIdentitySeedAndIncrement is broken as well, it's still showing as a difference in my reports.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6669

PostPosted: Mon Mar 04, 2013 4:41 pm    Post subject: Reply with quote

Thanks for your post. Please feel free to download 10.2.3.1 for now:
ftp://F0070239:i7ePnCcG@supportftp.red-gate.com/users/F0070239/sqlcompare_10.2.3.1.exe

There is a known issue with reports in the latest version ( SC-6165 ).
Back to top
View user's profile Send private message
vincentj



Joined: 17 Feb 2011
Posts: 36

PostPosted: Mon Mar 04, 2013 4:54 pm    Post subject: Reply with quote

Great, thanks!

At some point I would like to use the new /include:StaticData feature because it'll help speed up our deployments. Am I going to run into the same error if I try to use that with my filter files?
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6669

PostPosted: Wed Mar 06, 2013 5:04 pm    Post subject: Reply with quote

Hi,

As far as I am aware, the tables involved in static data transfer are the ones mentioned in RedgateDatabaseInfo.xml (the configuration file that SQL Compare/Source Control creates for you).

I'll try to get clarification on this.
Back to top
View user's profile Send private message
Admin
Site Admin


Joined: 15 Aug 2004
Posts: 9

PostPosted: Fri Mar 08, 2013 10:52 am    Post subject: Reply with quote

The /include:StaticData argument takes the tables it will modify from the RedGateDatabaseInfo.xml file. If you compare form a static script, you can try first modifying that file and putting the tables whose data you want to sync in the DataFileSet element.
Back to top
View user's profile Send private message Send e-mail
howarthcd



Joined: 16 May 2007
Posts: 50

PostPosted: Mon May 20, 2013 3:22 pm    Post subject: Reply with quote

Hi Red-Gate

It's been four months since we initially reported the filter bug (for which you created SC-6165).

Are you able to confirm when this issue will be resolved?

Thanks
Chris
Back to top
View user's profile Send private message
sheldonhull



Joined: 10 Jun 2013
Posts: 1

PostPosted: Mon Jun 10, 2013 7:16 pm    Post subject: Reply with quote

I'm having this issue as well. Any help?
Back to top
View user's profile Send private message
Michelle Taylor



Joined: 30 Oct 2006
Posts: 528
Location: Red Gate Software

PostPosted: Tue Jun 11, 2013 11:28 am    Post subject: Reply with quote

Have you tried the latest version (linked in the announcement above; http://downloads.red-gate.com/checkforupdates/SQLCompare/SQLCompare_10.4.8.87.exe or available through Check for Updates)? SC-6165 should be fixed in this version for identical objects in reports.
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