v10 command line not working in v11

• 
  What error messages are you seeing?

  Mike U May 27, 2015 06:35

  - 0 +
• 
  Hi Mike. The error message is below. Thanks.
  
  Exception Message: SQL Compare returned an exit code of 64. Return code was non-zero. Data Diff script generation cannot continue. (type Exception)

  Andrejs May 27, 2015 10:23

  - 0 +
• 
  Hi. Also, I don't know if this helps, but in our build log we get the text below. (I put X's in place of the serial number)
  
  
  SQL Compare: activated, edition: professional, serial number: XXX-XXX-XXXXXX-XXXX
  SQL Compare Command Line V11.1.3.30
  ==========================================================================================================================================
  Copyright Copyright c 1999 - 2015 Red Gate Software Ltd
  
  Registering data sources
  Creating mappings
  Comparing
  Applying Command Line Items (This is as far as it gets)

  Andrejs May 27, 2015 10:35

  - 0 +
• 
  Can you modify your script to print the actual command line it's running? The error code implies that the arguments are invalid, but the arguments you're using should be fine. Unfortunately I can't tell whether they're OK or not without knowing what values are being substituted in place of your variables.

  Mike U May 27, 2015 11:29

  - 0 +
• 
  Hi. Below are the values. Like I said, this exact string works with v10. Thanks so much for your help!
  
  /Server1:DEVPCHOICEWEB5FUSNTEAMBUILD01 /db1:MaxDir /Server2:DEVPCHOICEWEB5FUSNQASQL01 /db2:MaxDir /Filter:"file:C:Usersdt0fof6p.NAMCKAppDataLocalTempBuildAgent351Assembliesfusiondbcomparefilter.scpf" /Options:IgnorePermissions,IgnoreWhitespace,IgnoreStatistics,IgnoreCollations,IgnoreFileGroups,IgnoreUserProperties,IgnoreWithElementOrder,IgnoreDatabaseAndServerName /ScriptFile:"C:Builds351Fusion_2010PCDEV03_Dev MasterBinariesSyncScriptsMaxDir.sql" /force

  Andrejs May 27, 2015 13:48

  - 0 +
• 
  Those look like they should be OK. I think that there might be some more error output going to stderr that isn't getting captured by whatever tool you're using to run the SQLCompare.exe. Mechanisms for capturing that output vary depending on the tool you're using, but from the standard command prompt you need to add

  2>&1
  

  to the end of the command.
  
  Hopefully the stderr output will provide more information about what Compare thinks is wrong with the command line.

  Mike U May 27, 2015 14:39

  - 0 +
• 
  Hi, I just ran the command line in the command prompt on the build machine. It gave me one additional error. It gave me a URI error. Any ideas?
  
  
  SQL Compare Command Line V11.1.3.30
  =======================================================
  Copyright Copyright c 1999 - 2015 Red Gate Software Ltd
  
  Registering data sources
  Creating mappings
  Comparing
  Applying Command Line Items
  Error: URI formats are not supported.

  Andrejs May 27, 2015 15:12

  - 0 +
• 
  Yes. It's the file: prefix in the filter argument. If you can get that stripped off, everything should work properly.

  Mike U May 27, 2015 15:41

  - 0 +

Add comment

Please sign in to leave a comment.