Tables showing as not existing in both source and target
delapohl
Posts: 5 New member
in SQL Compare
SQL Compare v12.4.12.5042 Standard.
When I compare two similar databases, 16 tables are showing up as "only in" both the source and the target. All of these tables actually exist on both the source and target. If I run the same comparison while running SQL Compare as Administrator, this issue does not occur. Another user at our shop tried it with his copy of SQL Compare, and he also does not see this issue.
Is there some metadata associated with my user that I can delete to resolve this issue?
When I compare two similar databases, 16 tables are showing up as "only in" both the source and the target. All of these tables actually exist on both the source and target. If I run the same comparison while running SQL Compare as Administrator, this issue does not occur. Another user at our shop tried it with his copy of SQL Compare, and he also does not see this issue.
Is there some metadata associated with my user that I can delete to resolve this issue?
Tagged:
Best Answer
-
Rob C
Posts: 419 Gold 2
Hi @delapohl
It looks like something has gone awry with the mappings. Are the 16 tables all part of the same schema? If so you may need to check the owner mappings - https://documentation.red-gate.com/display/SC13/Mapping+owners - and ensure that they are mapped correctly.
Software Engineer
Redgate Software
Answers