Difference found or not .. make up your mind SSC !!

ABS

Hi All,

somehow I can not wrap my mind around this one. so a question for u guys as many know more than only me.

DB: SQL server 2016/2017
SSMS : v2017.9.1
SSC : 5.7.6.6321
SC TFS : unknown

work: making changes to a table. dropping IX en FK en PK and creating ColumnStoreindex, PK and UC.

eventually the SSC commit tab shows the following difference (ordering of the commands)
Database version

1. table definition
2. Add PK
3. create Columnstore index
4. add UC

Latest SC version

1. table definition
2. Add PK
3. add UC
   
4. create Columnstore index

the ordering is found as a difference. this does not matter to me so during checkin the following error occures : 

     CheckIn returned with ChangeSet ID=0, nothing to Check in?

     Didn't expect 0 actual 0

so .. checking my tfs branch .. 
TFS branch

1. table definition
2. Add PK
3. create Columnstore index
4. add UC

are the environments (three way compare) is corrupted ? 
working base and transient are the same as tfs and database

I unlinked and linked the DB. thinking it would be a workspace issue. Get latest tab is empty!!

somehow, somewhere, something is wrong
can anybody enlighten me .. any sollution or workaround would be very welkom.

Cherio

ABS

Tianjiao_Li

Can you upgrade to the latest version (7.0.22.9288) of SQL Source Control and test again? Note that you may need to enable frequent update release (Help-> Configure frequent update ->Show frequent updates releases).

ABS

Hi Tianjiao,

Thank you for the comment, I did the upgrade and checked for differences 

after upgrade, before any additional change:
no difference found ..
great!, ... or .. maybe not so great?

after adding a column (a additional change) :
the new column is found as a difference
AND the command ordering is seen as a difference.

so .. the upgrade is a workaround and not a real sollution .. SSC still thinks there is a difference but it ignores the difference when the only difference is the ordering of commands and maybe more differences.

does anybody have any suggestion

anything would be great!

Cheers ABS

Tianjiao_Li

Hi @ABS

When there is an actual difference, in your case a new column, the difference viewer will highlights any visual difference between the source object and target object. This is unfortunately due to the limit of the difference algorithm we use behind the scene...