sp_refreshview in output file

[Brujah]

Hi

When using Sql Compare 10 thru command line, I got in my output:
EXEC sp_refreshview N'[Schema].[Name]'
for every view in my database

Is there a way to disable this?

I'm using it to compare 2 SQL Source Control scripts folders

C:\Program Files (x86)\Red Gate\SQL Compare 10\SQLCompare.exe /scr1:"C:\dB52WorkDir\Jenkins217209\Trunk\sql\Redgate" /scr2:"C:\dB52WorkDir\Jenkins217209\Tag\sql\Redgate" /Options:Default,CaseSensitiveObjectDefinition,DoNotOutputCommentHeader /ScriptFile:"C:\dB52WorkDir\Jenkins217209\Change.sql" /Include:Identical /Force

[Brian Donahue]

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
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521

[Brujah]

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

[Brian Donahue]

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
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521

[Brian Donahue]

[Brian Donahue]

SQL Compare 10.1 now has an /assertidentical switch that will prevent the exec tasks from failing on identical databases.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521

[hugo]

[Brian Donahue]

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
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521

[Brian Donahue]

Sorry -- sp_refreshiew being added, probably a bug.
Error code 63 unless you use /Include:Identical, a design issue.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521