Compare Tables with Different Names

baschroeder

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

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