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

"CreateFromIntersection" - Can't see all tables

ampoampo Posts: 16

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.


  • Options
    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
Sign In or Register to comment.