What are the challenges you face when working across database platforms? Take the survey
Options

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

Comments

  • Options
    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
Sign In or Register to comment.