"CreateFromIntersection" - Can't see all tables

ampoampo Posts: 16
edited July 6, 2009 7:48AM in SQL Comparison SDK Previous Versions
Hi.

After getting Source DB tables and Target DB tables, I user CreateFromIntersection to get list of tables from both.

I have a table that 100% exists in both but it isn't in the result list...

Any idea why it isn't there?

Thanks for your help.
· Share on Twitter

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    In order for CreateFromIntersection to map tables, the tables must have "matching" primary keys or unique indexes in both databases.

    All tables and views should appear in the mappings collection if the names and schemata match up, but they may be ineligible for comparison.

    Programatically, you can check the "Status" property on each mapping to see if the data in the mapped table or view will actually be compared. If not, then you can add primary keys or map manually. Please see the following KB for example code.

    http://www.red-gate.com/support/Knowled ... apping.pdf
    · Share on Twitter
Sign In or Register to comment.