How can we help you today? How can we help you today?

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

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



ABS
0

Comments

3 comments

Sort by
  • 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).
    Tianjiao_Li
    0
  • 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
    ABS
    0
  • 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...
    Tianjiao_Li
    0

Add comment

Please sign in to leave a comment.