Bug? - SQLCompare 6.1 doesn't refresh views with drop column

slhale

It appears that if a table is only altered by dropping one or more columns, SQLCompare 6.1.053 does not generate sp_refreshview statements for assciated views causing the following error when one of those existing views is accessed:

Msg 4502, Level 16, State 1, Line 1
View or function '<view>' has more column names specified than columns defined.

Andras B

slhale wrote:

It appears that if a table is only altered by dropping one or more columns, SQLCompare 6.1.053 does not generate sp_refreshview statements for assciated views causing the following error when one of those existing views is accessed:

Msg 4502, Level 16, State 1, Line 1
View or function '<view>' has more column names specified than columns defined.

Many thanks for reporting this. I have raised this as a bug, and we will fix this in a future version.

Regards,
Andras

Eddie D

I am pleased to inform you that we have fixed this problem in the recently released SQL Compare V.7.

If you have a valid Support & upgrades option, you can download SQL Compare V.7 using the 'Check for updates' mechanism (SQL Compare GUI ->Help ->Check for updates)

or download using this link: HERE

SQL Compare V.7 will install along side any previous versions of the software.

Many Thanks
Eddie