Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Yessoft - SQL Server compare Expand / Collapse
Author
Message
Posted Wednesday, July 15, 2009 8:23 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Monday, April 07, 2014 10:25 AM
Points: 715, Visits: 1,018
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
Post #753504
Posted Wednesday, July 15, 2009 8:36 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 8:15 AM
Points: 3,068, Visits: 4,639
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.
Post #753521
Posted Wednesday, July 15, 2009 8:39 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Monday, April 07, 2014 10:25 AM
Points: 715, Visits: 1,018
yes, in SQL Server 2000 database i did not update statistics in the 2005 database i have updated the statistics
Post #753526
Posted Friday, June 17, 2011 10:15 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 16, 2013 7:10 AM
Points: 2, Visits: 124
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
Post #1127496
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse