How to show DB statistics in the SQL Compare?

ohamadaohamada Posts: 3 New member
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:

Answers

  • 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?
  • 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 …...
  • 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
  • Alex BAlex B Posts: 757 Diamond 1
    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?
Sign In or Register to comment.