Compare Tables with Different Names

baschroederbaschroeder Posts: 8
edited June 8, 2010 12:48AM in SQL Compare Previous Versions
We have a series of tables in two different systems, the tables were built from the same source, but got different names in each systems database. Would like to be able to compare these two sets of tables if possible, but did not see a way to set up a way to map them to each other.

Thanks
Brad
· Share on Twitter

Comments

  • David AtkinsonDavid Atkinson Posts: 1,458 Rose Gold 2
    Sorry, there's no easy way to do this. You could possibly take a copy of the database and use the Smart Rename feature in SQL Refactor before running the comparison, but this is less than ideal. This is something that comes up a fair bit so we'll consider this in a future release.

    David Atkinson
    Red Gate Software
    David Atkinson
    Product Manager
    Redgate Software
    · Share on Twitter
Sign In or Register to comment.