Cmd Line: objects are identical or no objects selected

• 
  Ahh...figured it out. The "no objects have been selected" refers to the things you want to synchronize after the compare is complete. It is not the things you want to compare.
  :roll:

  SeaSharp September 22, 2011 10:31

  - 0 +
• 
  Thanks for posting your solution.
  
  Let us know if you have any other problems.

  Chris Auckland September 26, 2011 07:35

  - 0 +
• 
  Thanks Chris. So, is there a way to execute JUST the compare from the command line using a SCP? I'm trying to integrate with CruiseControl.Net. I don't want to sync, just compare.

  SeaSharp September 26, 2011 09:31

  - 0 +
• 
  Yes, if you don't use the /synchronize(/sync) switch, then only the compare operation will be performed.
  
  To synchronize, you have to specify the /sync switch.

  Chris Auckland September 26, 2011 09:33

  - 0 +
• 
  I'm not using that switch. Yet, I get the error message that there are no objects to compare. This is all I'm doing...

  sqlcompare /Project:"C:\Whatever.scp"
  

  SeaSharp September 26, 2011 09:40

  - 0 +
• 
  This is a bit strange. The command line comparison should be exactly the same as the GUI comparison.
  
  What differences are being reported in the GUI? Are the objects listed in any of the 'objects with differences' groups in the top of the results grid, or are the differences only noticed in the SQL Differences pane at the bottom of the screen?

  Chris Auckland September 26, 2011 09:55

  - 0 +
• 
  In the GUI, at the top grid, I have:
  
  + 102 objects that exist in both but are different
  + 2 objects that exist only in <ServerName>.<DatabaseName>
  + 808 identical objects
  
  All of the 102 differences are found in stored procedures. When I click the stored procedure name it brings up the SQL pane and highlights the difference in green. They are definitely different.
  
  This is what the compare looks like when executed from the command line:
  

  C:\Program Files (x86)\Red Gate\SQL Compare 9>sqlcompare /Project:"C:\Whatever.scp"
  SQL Compare Command Line V9.0.0.79
  ==============================================================================
  Copyright c Red Gate Software Ltd 1999-2011
  
  Serial Number: <My Serial Number>
  
  Registering data sources
  Creating mappings
  Comparing
  Applying project settings
  Error: The selected objects are identical or no objects have been selected in
  the comparison.
  

  SeaSharp September 26, 2011 10:18

  - 0 +
• 
  What happens if you use the command line switches rather than referencing a project file? e.g.
  
  C:\Program Files (x86)\Red Gate\SQL Compare 9>sqlcompare /s1:MySourceServer /db1:MyDB /s2:MyTargetServer /db2:MyDB /options:default

  Chris Auckland September 26, 2011 12:10

  - 0 +
• 
  It did work with the command line. But, it also defeats the purpose of having all my settings wrapped up in the project file.

  SeaSharp September 27, 2011 11:42

  - 0 +
• 
  I haven't been able to reproduce this yet.
  
  Does the problem remain if you create a brand new project file?
  
  Also, could you try using the /Include:Indentical switch with the project file?
  
  If neither of these make a difference, would you be able to send me a SQL Compare snapshot of the source and target schemas, and also the project file?
  
  I should then be able to recreate the project here.

  Chris Auckland September 30, 2011 04:18

  - 0 +
• 
  I tried using the /Include:Indentical switch. I got an error message stating the switch is not allowed when specifying a project file.
  
  I created a new project file from scratch. It still had the same problem
  
  Unfortunately, I cannot send the schema because it is a sensitive problem domain related to safety & security. I realize that limits your ability to help me. Perhaps I can try to reproduce the problem with a new mock database. I'll see what I can do.

  SeaSharp September 30, 2011 11:38

  - 0 +
• 
  That would be great if you could.
  
  You also might like to try using an XML arg file instead of the project file as a workaround. You reference the arg file like you reference the project file, but it's not as easy to create as there isn't a UI for it.

  Chris Auckland October 04, 2011 10:33

  - 0 +
• 
  I am also having this problem. I have 7 differences in my project but I get the same error. I am also using a project file.
  
  Error: The selected objects are identical or no objects have been selected in
  the comparison.
  
  I tried adding the include statement to my xml document but I want to use 3 types in my include statement so I get differences, missing and add but when I put that in my xml file I get this error.
  
  Error: The /include and /project or /filter switches cannot be specified
  together with anything other than /include:identical

  bcpreece November 02, 2011 12:23

  - 0 +
• 
  Was having this problem and you guys cleared it up. On your second post you mentioned selecting the "Items for synchronization". So in my project I selected what I needed saved the project and now it displays the results.

  Grimbear13 November 02, 2011 14:57

  - 0 +

Add comment

Please sign in to leave a comment.