Yessoft - SQL Server compare

  • Hi,

    I'm using the software (Yessoft - SQL Server compare) to compare a database in SQL Server 2000 with a database in SQL Server 2005.

    Some tables return diffente number of record count.

    But when i count it by query (select count(*) from table_name) the results between the two databases are the same.

    I think that this tool (Yessoft - SQL Server compare) is no good to compare two databases that are in diferente compatibility levels.

    Did you experienced this allready?

    thank you

  • Most likely Yessoft is looking at table stats rather than actually counting rows.

    Are perhaps some table stats out of date?

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
  • yes, in SQL Server 2000 database i did not update statistics in the 2005 database i have updated the statistics

  • Why don't you check out dbForge? Seems to be a very promising tool that offers more features than most popular ones in the market.

    HTH.

    Thanks.

    Rohit

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply