Display Table Schema
ag
Posts: 2
SQL Compare displays the object schema (or owner) name in the list of objects with/without differences. For some reason, SQL Data Compare does not do that, at least by default.
Is it possible somehow to get SQL Data Compare to do the same thing? It's very confusing at times because we have databases with many schemas and sometimes tables with the same names in the different schemas.
Is it possible somehow to get SQL Data Compare to do the same thing? It's very confusing at times because we have databases with many schemas and sometimes tables with the same names in the different schemas.
Comments
"I am using SQL Data Compare 7.0
This is a new project, I just go to 'Tables & Views' to pick the list of
tables to compare. I was wondering if I could do something to see the
schema names in that view."
If you click on the Remap Objects tab in your project configuration, it displays the table owner and allows you to map/unmap tables and to map owners. Is this what you meant?