What are the challenges you face when working across database platforms? Take the survey
Options

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

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