Data Compare Slow with SQL 2005

Paul InghamPaul Ingham Posts: 3
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?

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    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.
  • 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
  • Brian DonahueBrian Donahue Posts: 6,590 New member
    Hi Paul,

    Sorry, I have no idea. Can you please write [email protected] with the migration script attached or enough of the script for us to look into it?

    Thanks.
Sign In or Register to comment.