I'm using SQL Compare V10 to compare tables between a Production and QA database. In this situation, the Prod and QA databases use the same table objects, however they are owned by a different schema:
Example: In Prod we have PROD.TABLE1, in QA we have QA.TABLE1
I have mapped owners PROD to QA so they are treated as equivalent, however these names are flagged as differences in the output/report.
I understand that they are different due to different names, but I though that was the whole purpose of mapping owners(schemas) ?
I could not find an option work around this, any ideas?