Compare 2 tables in same db?

jflorajflora Posts: 3
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


  • 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
    Head of DBA Tools
    Red Gate Software Ltd
  • Yes, that worked.
    Thank you.
    Judy Flora
This discussion has been closed.