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

• 
  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 D April 29, 2014 10:57

  - 0 +
• 
  yes the include switch

  <include>Identical</include>
  

  in the Argfile sorted thanks. It is pretty obvious now that was what was missing

  Angus Neilson April 29, 2014 11:17

  - 0 +
• 
  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 Neilson April 29, 2014 11:29

  - 0 +
• 
  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 D April 30, 2014 05:07

  - 0 +
• 
  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 Neilson April 30, 2014 11:15

  - 0 +
• 
  Using both /Include:Identical and /Exclude:Identical switches with sqldatacompare command line prevents the execution to exit with error code 63 in case both databases are identical and also doesn't generate a .csv report for each identical object
  
  It only generates the "Results Summary.csv" report file and still an individual .csv file for each different object
  
  Example
  
  sqldatacompare /Include:Identical /Exclude:Identical /server1:.. /database1:.. ...
  

  Nicols May 28, 2018 14:31

  - 0 +
• 
  Hi Nicols
  
  Thanks for your post. 
  
  I think it would be better if a new topic was created for this given how old the original post was. 
  Anyway, the 'exclude' switch will be applied as it overrides the 'include' one. Therefore, identical results will be missing from the reports. 
  
  Please remember that if you have a support contract you can always send us a ticket so that a dedicated product specialist can investigate your issues. 
  
  Kind regards
  
  Richard Lynch. 

  RichardL May 29, 2018 14:06

  - 0 +
• 
  Hi RichardL
  
  Thanks for your reply
  
  Actually I just wanted to share my findings for people with the same requirements
  
  Kr,
  
  Nicolas

  Nicols May 30, 2018 16:07

  - 0 +
• 
  Hi Nicols
  
  Thanks for your reply. 
  
  Sure, no worries. 
  
  Thanks again for the post. 
  
  Richard. 

  RichardL May 30, 2018 16:56

  - 0 +

Add comment

Please sign in to leave a comment.