Compare Tables within the same database

WindyCityGirl

Hello,

We have implemented some logical partitioning (same table multiple times) within our databases - I need to keep their definition's in sync. It would help if we could link/create match pairs to help with this and the pairing should include schema as well. As data gets bigger and bigger more people will/should be doing this for performance improvements.

Thank You!

mikejansen

I have done this by making the source and destination databases the same and then using the Table Mapping tab before comparing to map the tables you want to compare.

WindyCityGirl

Thank you this is a great suggestion! I will try this.