How to show DB statistics in the SQL Compare?

ohamadaohamada Posts: 3 New member
in 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
Tagged:
· Share on Twitter

Answers

  • Alex BAlex B Posts: 1,157 Diamond 4
    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
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
    · Share on Twitter
  • ohamadaohamada Posts: 3 New member
    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 …...
    · Share on Twitter
  • ohamadaohamada Posts: 3 New member
    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
    · Share on Twitter
  • Alex BAlex B Posts: 1,157 Diamond 4
    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
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
    · Share on Twitter
Sign In or Register to comment.