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

Nice Upgrade!!

DataCompare has been a solid product for some time. Performance seems to be up a little bit. The biggest downfall I see is the primary key requirement. We have a lot of third party application databases where we cannot implement PKs and it would be incredibly nice to be able to compare these rows. Perhaps it could be done with a checksum where a PK doesn't exist?

We use SQL LiteSpeed for our backup compression, so we don't have any RedGate compressed backups to work with, but the uncompressed backup comparison works very well!

Another option nice to have would be exporting each table as a different sheet in an Excel document for ease of management!

Thanks!
Paul
P
0

Comments

3 comments

Sort by
  • Robert C
    Hi,

    When you mention the PK requirement, do you mean in general or for comparison to backups?

    The requirement for backups is that there must be some index defined on the table - it doesn't have to be a primary key, though if it isn't, you'll need to select it by hand (in the Tables & Views tab of the project configuration wizard). For live database to live database, you can choose any old comparison key, though those that have matching indexes will be faster.

    Out of curiosity, were the backups you tried originally in LiteSpeed's format (then extracted using their decompression tool), or were they just native SQL Server backups from the start?

    I've noted the feature request for the Excel export, though I can't promise anything at this stage, I'm afraid.

    Many thanks,
    Robert
    Robert C
    0
  • P
    Regarding the PK requierment, I meant in general. Thanks for the info on the comparison. Our backups are originally in LiteSpeed's format. I'm assuming there is no support for this, correct?

    Thanks!
    Paul
    P
    0
  • Robert C
    Hi Paul,

    Yes, you're correct, there's no support for Litespeed directly, I'm afraid. I was just pleased to know it worked having been converted back into native MTF format.

    Thanks,
    Robert
    Robert C
    0

Add comment

Please sign in to leave a comment.