sp_refreshview in output file

• 
  If I remember correctly, a side-effect of using /Include:Identical is that all views are refreshed. Omitting this will script a refresh view only for views that are different.

  Brian Donahue February 03, 2012 12:40

  - 0 +
• 
  Hi brain
  
  I've included this switch to suppress the exit code if the two data sources are identical.
  
  "If /Include:Identical is not set, and the data sources are identical, SQL Compare returns the error code 63."
  
  is there a way to to suppress this error code, but get rid off the sp_refreshview ?
  
  Thanks

  Brujah February 08, 2012 11:19

  - 0 +
• 
  That could be a problem. In the past, I have suggested wrapping the command into a batch file and then at the end, check for %ERRORLEVEL%==63 and then EXIT /B with error code 0.

  Brian Donahue February 08, 2012 12:02

  - 0 +
• 

  SQLCompare.exe /db1:...
  IF %ERRORLEVEL% EQU 63 GOTO EQUAL 
  EXIT /B %ERRORLEVEL%
  EQUAL:
  EXIT /B 0
  

  Brian Donahue February 08, 2012 12:10

  - 0 +
• 
  SQL Compare 10.1 now has an /assertidentical switch that will prevent the exec tasks from failing on identical databases.

  Brian Donahue March 28, 2012 10:26

  - 0 +
• 

  Brian Donahue wrote:

  SQL Compare 10.1 now has an /assertidentical switch that will prevent the exec tasks from failing on identical databases.

  
  Apparently this patch "suggest" I need to buy version 10.1? or is version 10 free for those of us having version 9?

  hugo April 23, 2012 13:35

  - 0 +
• 
  Hi Hugo,
  
  If you have a support agreement that was current at the time of the upgrade, you would get major upgrades for free. Usually a major-version is a paid upgrade.
  
  Just to clarify, this is not a patch or a bugfix - it is a change in design because something that had been acceptable behavior previously is now unwanted simply because of the selling of Continuous Integration that we are currently engaged in.
  
  If you want to keep the current version, there is still the option of wrapping the compare task into a batch file as I'd mentioned previously.

  Brian Donahue April 24, 2012 04:14

  - 0 +
• 
  Sorry -- sp_refreshiew being added, probably a bug.
  Error code 63 unless you use /Include:Identical, a design issue.

  Brian Donahue April 24, 2012 08:40

  - 0 +
• 
  Hi there
  
  I think this behaviour is improved in our latest Frequent Updates release (11.1.7.47) - Compare should now refresh views less often; it will no longer refresh views unrelated to the deployment and will refresh no views if the 'Include Dependencies' option is disabled

  Mark J March 05, 2015 12:23

  - 0 +

Add comment

Please sign in to leave a comment.