How can we help you today? How can we help you today?

Data Compare Slow with SQL 2005

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?
Paul Ingham
0

Comments

3 comments

Sort by
  • Brian Donahue
    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.
    Brian Donahue
    0
  • Paul Ingham
    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
    Paul Ingham
    0
  • Brian Donahue
    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.
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.