How can we help you today? How can we help you today?

Tables showing as not existing in both source and target

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?



Michael Pohl
0

Comments

2 comments

Sort by
  • Rob C
    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.

    Rob C
    0
  • delapohl
    Thanks Rob, that pointed me in the right direction. I had manual mappings for these tables from a previous release. I restored the default mappings for those tables, and that resolved the issue.
    delapohl
    0

Add comment

Please sign in to leave a comment.