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

Compare 2 tables in same db?

Is it possible to compare data in 2 tables on the same database?

We are replicating 2 tables with identical columns in the same database, in order to test changes in our replication scripts.

Judy Flora
jflora
0

Comments

2 comments

Sort by
  • James Moore
    Yes,

    This should be possible - If you create a new comparison project and set the source and destination db to be the same then go to the remappings tab and unmap everything then map you two tables together (You might need to map the columns together as well) - then switch back to the "Tables and Views" tab and make sure that the compairson key is set appropriately for that table and its included in the comparison then hit compare now and it should work.

    Let me know if you have any problems,

    - James
    --
    James Moore
    Red Gate Software Ltd
    James Moore
    0
  • jflora
    Yes, that worked.
    Thank you.
    Judy Flora
    jflora
    0

Add comment

Please sign in to leave a comment.