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

Compare Tables with Different Names

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
baschroeder
0

Comments

1 comment

Sort by
  • David Atkinson
    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
    0

Add comment

Please sign in to leave a comment.