Options

Data Compare Slow with SQL 2005

Paul InghamPaul Ingham Posts: 3
edited May 29, 2007 5:38AM in SQL Data Compare Previous Versions
Hi

I have found that using Data Compare 5 with 2 SQL 2005 SP2 databases is slow by a huge amount. When comparing the two databases on SQL Server 2000 it takes 2 minutes on SQL 2005, i am 20 minutes in and it is still stuck on 12%.

Does anyone have any ideas?
· Share on Twitter

Comments

  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hi Paul,

    Thanks for asking. I can't find the specific case, but I do recall an issue where SQL Server needed to convert data internally and this caused a performance hit in the upgrade script. Can you please ensure you've got SQL Bundle 5.3? I believe the problem had been worked around in the newest version.
    · Share on Twitter
  • Options
    Paul InghamPaul Ingham Posts: 3
    edited May 29, 2007 5:39AM
    Hi Brian

    The versions i am having problems with is SQL Compare 5.3.0.44 and Data Compare 5.3.0.68.

    Cheers,
    Paul
    · Share on Twitter
  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hi Paul,

    Sorry, I have no idea. Can you please write support@red-gate.com with the migration script attached or enough of the script for us to look into it?

    Thanks.
    · Share on Twitter
Sign In or Register to comment.