Yessoft - SQL Server compare

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Yessoft - SQL Server compare

Yessoft - SQL Server compare

Rate Topic

Display Mode

Topic Options

Author

Message

river1

Posted Wednesday, July 15, 2009 8:23 AM

Say Hey Kid

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 6:56 AM
Points: 679, Visits: 953

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

PaulB-TheOneAndOnly

Posted Wednesday, July 15, 2009 8:36 AM

Hall of Fame

Group: General Forum Members
Last Login: Yesterday @ 3:56 PM
Points: 3,016, Visits: 4,469

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

river1

Posted Wednesday, July 15, 2009 8:39 AM

Say Hey Kid

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 6:56 AM
Points: 679, Visits: 953

yes, in SQL Server 2000 database i did not update statistics in the 2005 database i have updated the statistics

Post #753526

Rohit Kshirsagar-240107

Posted Friday, June 17, 2011 10:15 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, May 10, 2013 8:44 AM
Points: 2, Visits: 119

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 »

Permissions