I'm working on an upgrade project that requires me to generate a data comparsion between 2 databases. The 2nd database is a upgrade of the first and I'm thinking of using Redgate compare to achieve this.
It's very convoluted but my simple question is this: Is it possible to use data compare to generate difference between db's with different schemas? (Only columns are added - I can't see any that have been deleted as yet).
Any advice/help appreciated.