Compare 2 tables in same db?

jflorajflora Posts: 3
edited June 9, 2006 9:14AM in SQL Data Compare Previous Versions
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
· Share on Twitter

Comments

  • James MooreJames Moore Posts: 252
    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
    · Share on Twitter
  • jflorajflora Posts: 3
    Yes, that worked.
    Thank you.
    Judy Flora
    · Share on Twitter
This discussion has been closed.