July 15, 2009 at 8:23 am
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
July 15, 2009 at 8:36 am
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.July 15, 2009 at 8:39 am
yes, in SQL Server 2000 database i did not update statistics in the 2005 database i have updated the statistics
June 17, 2011 at 10:15 am
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