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

How to show DB statistics in the SQL Compare?

I have trying to compare two databases and I can't find the differences in Statistics as it has be dropped and recreated  while Alter tables or while rebuilding tables
ohamada
0

Comments

4 comments

Sort by
  • Alex B
    Hi @ohamada,

    If you have not changed the default options, the option "Ignore statistics" is checked by default:
    ​

    so this may be what is occurring.

    Please check that and let me know!

    Kind regards,
    Alex
    Alex B
    0
  • ohamada
    Actually, I know about this option and it is not selected, my concern is why it is not showing on the left hand side pan in the list as Tables, Views, SP, Functions, etc …...
    ohamada
    0
  • ohamada
    in other DB Compare apps they list them separately same as Tables and Views so you can find out which tables has Statistics and generate the needed SQL script to update the other DB
    ohamada
    0
  • Alex B
    Hi @ohamada,

    Ah, righto, that section is the filter and it is only for filtering objects. 

    The Statistics are not categorized as a separate objects from the table they are created on (like indexes, constraints and DML triggers).  All of those will be contained with the table objects and show as differences there.

    Kind regards,
    Alex
    Alex B
    0

Add comment

Please sign in to leave a comment.