What are the challenges you face when working across database platforms? Take the survey

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?


Best Answer


  • Options
    delapohldelapohl Posts: 5 New member
    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.
Sign In or Register to comment.