Red Gate forums :: View topic - Error: The selected objects are identical or no objects ..
Return to www.red-gate.com RSS Feed Available

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

Error: The selected objects are identical or no objects ..

Search in SQL Data Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Angus Neilson



Joined: 29 Apr 2014
Posts: 4

PostPosted: Tue Apr 29, 2014 1:00 pm    Post subject: Error: The selected objects are identical or no objects .. Reply with quote

Hi
I have seen solutions for the same issue in SQL Compare but cannot seem to see where I can select the objects for deployment in SQL Data Compare .

this is the error (sensitive details redacted)
Quote:
C:\source\branches\Data\Projects\ZZReference\DataCompare>SQLDataCompare /Argfile:xjsjrrsdkdLiveReport.xml
SQL Data Compare: activated, edition: professional, serial number: 507-001-205889-95C7
Red Gate SQL Data Compare Command Line Utility V10.4.8.62
==============================================================================
Copyright c Red Gate Software Ltd 1999-2013

Loading synchronization parameters from project file: C:\source\branches\Data\Projects\ZZReference\DataCompare\ZZReferenceDataLiveToZZReferenceDataDev_xjsjrrsdkd.sdc
OK
Comparing database DEVSERVER.ZZReferenceData2 with database DEVSERVER.ZZReferenceData...
Registering databases
Mapping
Comparing databases
Error: The selected objects are identical or no objects have been selected in the comparison.


I just want a report of the differences in the Databases for this script and in this case they are identical which is valid not an error
_________________
Angus
Back to top
View user's profile Send private message
eddie davis



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

PostPosted: Tue Apr 29, 2014 3:57 pm    Post subject: Reply with quote

Thank you for your forum post.

Need to see the contents of your /Argfile:xjsjrrsdkdLiveReport.xml to answer correctly.

I suspect that you need to include the following switches in your xml argument file.

/IncludeAdditional
/IncludeMissing
/IncludeDifferent
Or user specified /Include[/list]

The command line help for SQL Data Compare is available via this LINK.

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
Angus Neilson



Joined: 29 Apr 2014
Posts: 4

PostPosted: Tue Apr 29, 2014 4:17 pm    Post subject: Reply with quote

yes the include switch
Code:
<include>Identical</include>
in the Argfile sorted thanks. It is pretty obvious now that was what was missing Smile
_________________
Angus
Back to top
View user's profile Send private message
Angus Neilson



Joined: 29 Apr 2014
Posts: 4

PostPosted: Tue Apr 29, 2014 4:29 pm    Post subject: Reply with quote

Although it then mean it genrates the whole data set into the reports I realy only wanted to generate a report is ther a way of doing this ?
_________________
Angus
Back to top
View user's profile Send private message
eddie davis



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

PostPosted: Wed Apr 30, 2014 10:07 am    Post subject: Reply with quote

Thank you for your replies.

The reporting module of SQL Data Compare simply exports the comparison results into a set of CSV files dependent upon the 'Rows to Include' option.

SQL Data Compare does not generate reports of the type (Interactive HTML, Simple HTML and XML) available in SQL Compare.

If you would like SQL Data Compare to generate reports similar to the report types available in SQL Compare, I recommend that you comment and vote on this SQL Data Compare User Voice TOPIC.

The User Voice Forum is the preferred method of submitting a feature request. The User Voice forum is actively monitored by the Product Managers and Development Teams. The more votes and comments a topic receives will increase its chances of being included in a future version of the product.

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
Angus Neilson



Joined: 29 Apr 2014
Posts: 4

PostPosted: Wed Apr 30, 2014 4:15 pm    Post subject: Reply with quote

Yes I would like that facility have added a post on User Voice
Always having to generate a full difference is not ideal with larger data sets but as we have to include identical I assume there is no other way at the moment. The Summary csv is fine fro our needs but can seem to be generated on its own
_________________
Angus
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