sp_refreshview in output file

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

sp_refreshview in output file

Postby Brujah » Wed Feb 01, 2012 2:52 pm

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
Brujah
 
Posts: 12
Joined: Wed Apr 02, 2008 10:53 am

Postby Brian Donahue » Fri Feb 03, 2012 6:40 pm

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
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Postby Brujah » Wed Feb 08, 2012 5:19 pm

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
 
Posts: 12
Joined: Wed Apr 02, 2008 10:53 am

Postby Brian Donahue » Wed Feb 08, 2012 6:02 pm

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
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Postby Brian Donahue » Wed Feb 08, 2012 6:10 pm

Code: Select all
SQLCompare.exe /db1:...
IF %ERRORLEVEL% EQU 63 GOTO EQUAL
EXIT /B %ERRORLEVEL%
EQUAL:
EXIT /B 0
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Postby Brian Donahue » Wed Mar 28, 2012 3:26 pm

SQL Compare 10.1 now has an /assertidentical switch that will prevent the exec tasks from failing on identical databases.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Re:

Postby hugo » Mon Apr 23, 2012 6:35 pm

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
 
Posts: 2
Joined: Mon Mar 26, 2012 8:14 pm

Postby Brian Donahue » Tue Apr 24, 2012 9:14 am

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
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Postby Brian Donahue » Tue Apr 24, 2012 1:40 pm

Sorry -- sp_refreshiew being added, probably a bug.
Error code 63 unless you use /Include:Identical, a design issue.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests